text: CREATE TABLE SECTION (building VARCHAR, room_number VARCHAR, semester VARCHAR, year VARCHAR, course_id VARCHAR); CREATE TABLE course (course_id VARCHAR, dept_name VARCHAR, title VARCHAR) -- Find the building, room number, semester and year of all courses offered by Psychology department sorted by course titles. SELECT T2.building, T2.room_number, T2.semester, T2.year FROM course AS T1 JOIN SECTION AS T2 ON T1.course_id = T2.course_id WHERE T1.dept_name = 'Psychology' ORDER BY T1.title CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR) -- Find the names of all instructors in computer science department SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.' CREATE TABLE instructor (name VARCHAR, dept_name VARCHAR, salary VARCHAR) -- Find the names of all instructors in Comp. Sci. department with salary > 80000. SELECT name FROM instructor WHERE dept_name = 'Comp. Sci.' AND salary > 80000 CREATE TABLE instructor (ID VARCHAR); CREATE TABLE teaches (ID VARCHAR) -- Find the names of all instructors who have taught some course and the course_id. SELECT name, course_id FROM instructor AS T1 JOIN teaches AS T2 ON T1.ID = T2.ID CREATE TABLE instructor (ID VARCHAR, dept_name VARCHAR); CREATE TABLE teaches (ID VARCHAR) -- Find the names of all instructors in the Art department who have taught some course and the course_id. SELECT name, course_id FROM instructor AS T1 JOIN teaches AS T2 ON T1.ID = T2.ID WHERE T1.dept_name = 'Art'