Find the kind of program which most number of students are enrolled in?
create table student_enrolment (degree_program_id varchar, PRIMARY KEY (degree_program_id)); create table degree_programs (degree_summary_name varchar, degree_program_id varchar, PRIMARY KEY (degree_summary_name))
select t1.degree_summary_name from degree_programs as t1 join student_enrolment as t2 on t1.degree_program_id = t2.degree_program_id group by t1.degree_summary_name order by count(*) desc limit 1