SELECT dept_name FROM course GROUP BY dept_name ORDER BY count(*) DESC LIMIT 3
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
select dept_name from course group by dept_name order by count ( * ) desc limit value
Find the names of the top 3 departments that provide the largest amount of courses ?