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
SELECT dept_name ,  AVG (salary) FROM instructor GROUP BY dept_name HAVING AVG (salary)  >  42000
[{'dept_name': 'Accounting', 'AVG (salary)': 48716.5925}, {'dept_name': 'Astronomy', 'AVG (salary)': 79070.08}, {'dept_name': 'Athletics', 'AVG (salary)': 77098.198}, {'dept_name': 'Biology', 'AVG (salary)': 61287.25}, {'dept_name': 'Comp. Sci.', 'AVG (salary)': 98133.47}, {'dept_name': 'Cybernetics', 'AVG (salary)': 96346.5675}, {'dept_name': 'Elec. Eng.', 'AVG (salary)': 74162.73999999999}, {'dept_name': 'English', 'AVG (salary)': 72089.04999999999}, {'dept_name': 'Finance', 'AVG (salary)': 105311.38}, {'dept_name': 'Geology', 'AVG (salary)': 99382.59}, {'dept_name': 'Languages', 'AVG (salary)': 57421.85666666667}, {'dept_name': 'Marketing', 'AVG (salary)': 84097.4375}, {'dept_name': 'Mech. Eng.', 'AVG (salary)': 79813.02}, {'dept_name': 'Physics', 'AVG (salary)': 114576.9}, {'dept_name': 'Pol. Sci.', 'AVG (salary)': 100053.07333333332}, {'dept_name': 'Psychology', 'AVG (salary)': 61143.05}, {'dept_name': 'Statistics', 'AVG (salary)': 67795.44166666667}]