What are the names and average salaries for departments with average salary higher than 42000?
SELECT dept_name ,  AVG (salary) FROM instructor GROUP BY dept_name HAVING AVG (salary)  >  42000
names and average salaries for departments refers to SELECT dept_name, AVG(salary); departments with average salary higher than 42000 refers to HAVING AVG(salary) > 42000;