How many courses does each department have?
select dept_name, count(*) from course group by dept_name
Order their names from greatest to least.
select dept_name from course group by dept_name order by count(*) desc
What are the top 3?
select dept_name from course group by dept_name order by count(*) desc limit 3