What is the name of the course that has the most student enrollment?
select t1.course_name from courses as t1 join student_course_enrolment as t2 on t1.course_id = t2.course_id group by t1.course_name order by count ( * ) desc limit 1
How many students are enrolled in French?
select count ( * ) from student_course_enrolment as t1 join courses as t2 on t2.course_id = t1.course_id where course_name = 'French'
What is the name of the course that has the least student enrollment?
select t1.course_name from courses as t1 join student_course_enrolment as t2 on t1.course_id = t2.course_id group by t1.course_name order by count ( * ) limit 1
How many students are enrolled in Chinese Painting?
select count ( * ) from student_course_enrolment as t1 join courses as t2 on t2.course_id = t1.course_id where course_name = 'Chinese Painting'
What is the ID of this student?
select student_id from student_course_enrolment as t1 join courses as t2 on t2.course_id = t1.course_id where course_name = 'Chinese Painting'
What other classes is this student taking?
select distinct course_name from student_course_enrolment as t1 join courses as t2 on t2.course_id = t1.course_id where student_id = '15' and course_name ! = 'Chinese Painting'