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
names of the 3 departments with the most courses refers to ORDER BY COUNT(*) DESC LIMIT 3;