Find the names of the top 3 departments that provide the largest amount of courses?
SELECT dept_name FROM course GROUP BY dept_name ORDER BY count(*) DESC LIMIT 3
top 3 departments = ORDER BY COUNT(*) DESC LIMIT 3; largest amount of courses refers to COUNT(*)