Skip to main content
Practice

10

sql​

-- Count how many classes each student is enrolled in
SELECT students.name AS student_name,
  COUNT(enrollments.class_id) AS class_count
FROM students
LEFT JOIN enrollments
  ON students.student_id = enrollments.student_id
GROUP BY students.name;

Want to learn more?

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