Capstone Project

Understand the idea

In this lesson, explore capstone project. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.

SELECT s.name, COUNT(*) AS enrollments FROM students s LEFT JOIN enrollments e ON e.student_id=s.id GROUP BY s.id;