text: CREATE TABLE course (title VARCHAR, dept_name VARCHAR) -- Find the title of course that is provided by Statistics but not Psychology departments. SELECT title FROM course WHERE dept_name = 'Statistics' EXCEPT SELECT title FROM course WHERE dept_name = 'Psychology' CREATE TABLE teaches (id VARCHAR, semester VARCHAR, YEAR VARCHAR) -- Find the id of instructors who taught a class in Fall 2009 but not in Spring 2010. SELECT id FROM teaches WHERE semester = 'Fall' AND YEAR = 2009 EXCEPT SELECT id FROM teaches WHERE semester = 'Spring' AND YEAR = 2010 CREATE TABLE student (name VARCHAR, id VARCHAR); CREATE TABLE takes (id VARCHAR) -- Find the name of students who took any class in the years of 2009 and 2010. SELECT DISTINCT T1.name FROM student AS T1 JOIN takes AS T2 ON T1.id = T2.id WHERE YEAR = 2009 OR YEAR = 2010 CREATE TABLE course (dept_name VARCHAR) -- Find the names of the top 3 departments that provide the largest amount of courses? SELECT dept_name FROM course GROUP BY dept_name ORDER BY COUNT(*) DESC LIMIT 3 CREATE TABLE course (dept_name VARCHAR, credits INTEGER) -- Find the name of the department that offers the highest total credits? SELECT dept_name FROM course GROUP BY dept_name ORDER BY SUM(credits) DESC LIMIT 1 CREATE TABLE course (title VARCHAR, credits VARCHAR) -- List the names of all courses ordered by their titles and credits. SELECT title FROM course ORDER BY title, credits