SELECT dept_name FROM instructor GROUP BY dept_name ORDER BY avg(salary) DESC LIMIT 1
Which department has the highest average instructor salary?
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
Which department has the highest average instructor salary ?