SELECT dept_name FROM instructor GROUP BY dept_name ORDER BY avg(salary) DESC LIMIT 1
Find the name of the department which has the highest average salary of professors.
SELECT dept_name FROM instructor GROUP BY dept_name ORDER BY avg ( salary ) DESC LIMIT 1
select dept_name from instructor group by dept_name order by avg ( salary ) desc limit value
Find the name of the department which has the highest average salary of professors .