been wanting to make a landing page where students in universities sign up, and they can see a leaderboard score of sign-ups per universities on the page as well. What is the best way to do this? Appreciate any feedback on this question, I am a new dev!

  • 0
    students.filter((e) => e.university === "university_name").length;
  • 0
    Assuming you're using sql you could do something like "SELECT university, COUNT(user) as signups From students group by university order by signups desc"? Well you might wanna do a join on universities though to store the names more efficiently. Also if it doesn't change frequently you should cache the result so it won't have to run all the time the page loads.
Add Comment