CREATE TABLE instructor (dept_name VARCHAR, salary INT)

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") > 42000