Skip to main content

3

sql

-- View course_progress table
SELECT * FROM course_progress;

-- Rank users by completion rate within each course
SELECT user_name,
       course_name,
       completion_rate,
       RANK() OVER (PARTITION BY course_name ORDER BY completion_rate DESC) AS rank,
       DENSE_RANK() OVER (PARTITION BY course_name ORDER BY completion_rate DESC) AS dense_rank
FROM course_progress;

Want to learn more?

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

sql