What are all the department names?
select dname from department
Order these descending by the number of students minoring in them.
select t1.dname from department as t1 join minor_in as t2 on t1.dno = t2.dno group by t2.dno order by count(*) desc
Which has the most?
select t1.dname from department as t1 join minor_in as t2 on t1.dno = t2.dno group by t2.dno order by count(*) desc limit 1