Skip to main content

3

sql

-- Count how many courses each user selected
SELECT u.name,
       (SELECT COUNT(*)
        FROM user_courses uc
        WHERE uc.user_id = u.user_id) AS course_count
FROM users u;

Want to learn more?

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

sql