text: CREATE TABLE instructor (dept_name VARCHAR, salary INTEGER) -- 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 CREATE TABLE instructor (name VARCHAR, salary INTEGER, dept_name VARCHAR) -- Find names of instructors with salary greater than that of some (at least one) instructor in the Biology department. SELECT name FROM instructor WHERE salary > (SELECT MIN(salary) FROM instructor WHERE dept_name = 'Biology') CREATE TABLE instructor (name VARCHAR, salary INTEGER, dept_name VARCHAR) -- Find the names of all instructors whose salary is greater than the salary of all instructors in the Biology department. SELECT name FROM instructor WHERE salary > (SELECT MAX(salary) FROM instructor WHERE dept_name = 'Biology') CREATE TABLE debate (Id VARCHAR) -- How many debates are there? SELECT COUNT(*) FROM debate CREATE TABLE debate (Venue VARCHAR, Num_of_Audience VARCHAR) -- List the venues of debates in ascending order of the number of audience. SELECT Venue FROM debate ORDER BY Num_of_Audience CREATE TABLE debate (Date VARCHAR, Venue VARCHAR) -- What are the date and venue of each debate? SELECT Date, Venue FROM debate CREATE TABLE debate (Date VARCHAR, Num_of_Audience INTEGER) -- List the dates of debates with number of audience bigger than 150 SELECT Date FROM debate WHERE Num_of_Audience > 150