Database: college_2
Question: What are the names and average salaries for departments with average salary higher than 42000?
SQL:
SELECT dept_name ,  AVG (salary) FROM instructor GROUP BY dept_name HAVING AVG (salary)  >  42000