What are the names of departments that have average salaries higher than 42000?
select dept_name from instructor group by dept_name having avg (salary) > 42000
Also, what are their average salaries?
select dept_name, avg (salary) from instructor group by dept_name having avg (salary) > 42000