Skip to main content

4

sql

-- Assign row numbers and split users into quartiles based on final scores
SELECT name, final_score,
  ROW_NUMBER() OVER (ORDER BY final_score DESC) AS row_num,
  NTILE(4) OVER (ORDER BY final_score DESC) AS quartile
FROM course_progress;

Want to learn more?

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

sql