Skip to main content

2

sql

-- Rank CodeFriends students within each class by score
SELECT name,
  class,
  score,
  RANK() OVER (
    PARTITION BY class
    ORDER BY score DESC
  ) AS rank_in_class
FROM scores;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql