How many students are there?
select count(*) from students
How many courses are there?
select count(*) from courses
What is the name of each course and the corresponding number of student enrollment?
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