SELECT dept_name FROM course GROUP BY dept_name ORDER BY count(*) DESC LIMIT 3
What are the names of the 3 departments with the most courses?
SELECT dept_name FROM course GROUP BY dept_name ORDER BY count ( * ) DESC LIMIT 3
select dept_name from course group by dept_name order by count ( * ) desc limit value
What are the names of the 3 departments with the most courses ?