Find the names and average salaries of all departments whose average salary is greater than 42000.
CREATE TABLE instructor (
    dept_name VARCHAR,
    salary INTEGER
)
SELECT dept_name, AVG(salary) FROM instructor GROUP BY dept_name HAVING AVG(salary) > 42000
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the names and average salaries of all departments whose average salary is greater than 42000. ### Input: CREATE TABLE instructor (
    dept_name VARCHAR,
    salary INTEGER
) ### Response: SELECT dept_name, AVG(salary) FROM instructor GROUP BY dept_name HAVING AVG(salary) > 42000