What are the names of the courses
select course_name from courses
Yes please
select t1.course_name, count ( * ) from courses as t1 join student_course_enrolment as t2 on t1.course_id = t2.course_id group by t1.course_name