SELECT dept_name ,  AVG (salary) FROM instructor GROUP BY dept_name HAVING AVG (salary)  >  42000
Find the names and average salaries of all departments whose average salary is greater than 42000.
SELECT dept_name , AVG ( salary ) FROM instructor GROUP BY dept_name HAVING AVG ( salary ) > 42000
select dept_name , avg ( salary ) from instructor group by dept_name having avg ( salary ) > value
Find the names and average salaries of all departments whose average salary is greater than 42000 .