Skip to main content

9

sql

-- CTE to find users with 2 or more courses
WITH multi_course_users AS (
  SELECT user_id, COUNT(*) AS course_count
  FROM user_courses
  GROUP BY user_id
  HAVING COUNT(*) >= 2
)
SELECT u.name, m.course_count
FROM multi_course_users m
JOIN users u ON u.user_id = m.user_id
ORDER BY u.name;

Want to learn more?

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

sql