CREATE TABLE takes (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, grade VARCHAR2)
CREATE TABLE course (course_id VARCHAR2, title VARCHAR2, dept_name VARCHAR2, credits NUMBER)
CREATE TABLE instructor (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, salary NUMBER)
CREATE TABLE prereq (course_id VARCHAR2, prereq_id VARCHAR2)
CREATE TABLE classroom (building VARCHAR2, room_number VARCHAR2, capacity NUMBER)
CREATE TABLE section (course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER, building VARCHAR2, room_number VARCHAR2, time_slot_id VARCHAR2)
CREATE TABLE advisor (s_ID VARCHAR2, i_ID VARCHAR2)
CREATE TABLE time_slot (time_slot_id VARCHAR2, day VARCHAR2, start_hr NUMBER, start_min NUMBER, end_hr NUMBER, end_min NUMBER)
CREATE TABLE department (dept_name VARCHAR2, building VARCHAR2, budget NUMBER)
CREATE TABLE teaches (ID VARCHAR2, course_id VARCHAR2, sec_id VARCHAR2, semester VARCHAR2, year NUMBER)
CREATE TABLE student (ID VARCHAR2, name VARCHAR2, dept_name VARCHAR2, tot_cred NUMBER)

Find the names and average salaries of all departments whose average salary is greater than 42000, show by the x axis from high to low.
SELECT dept_name, AVG(salary) FROM instructor GROUP BY dept_name ORDER BY dept_name DESC
SELECT "dept_name", AVG("salary") FROM "instructor" GROUP BY "dept_name" ORDER BY "dept_name" DESC