Skip to main content
Practice

8

sql​

SELECT user_id,
  course_name,
  progress_percent,
  CASE
    WHEN progress_percent = 100 THEN 'Completed'
    WHEN progress_percent >= 75 THEN 'Almost done'
    WHEN progress_percent >= 50 THEN 'Halfway'
    ELSE 'Just started'
  END AS completion_status
FROM course_progress;

Want to learn more?

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