List the name and the number of enrolled student for each course.
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
name of each course refers to course_name; number of enrolled student for each course refers to COUNT(*) with a JOIN between Courses table and Student_Course_Enrolment table on course_id;