text: CREATE TABLE course (title VARCHAR, course_id VARCHAR); CREATE TABLE prereq (prereq_id VARCHAR, course_id VARCHAR); CREATE TABLE course (course_id VARCHAR, title VARCHAR) -- What is the course title of the prerequisite of course Mobile Computing? SELECT title FROM course WHERE course_id IN (SELECT T1.prereq_id FROM prereq AS T1 JOIN course AS T2 ON T1.course_id = T2.course_id WHERE T2.title = 'Mobile Computing') CREATE TABLE student (id VARCHAR, tot_cred VARCHAR); CREATE TABLE advisor (i_id VARCHAR, s_id VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR) -- Find the name of instructor who is the advisor of the student who has the highest number of total credits. SELECT T2.name FROM advisor AS T1 JOIN instructor AS T2 ON T1.i_id = T2.id JOIN student AS T3 ON T1.s_id = T3.id ORDER BY T3.tot_cred DESC LIMIT 1 CREATE TABLE teaches (name VARCHAR, id VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR) -- Find the name of instructors who didn't teach any courses? SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches) CREATE TABLE teaches (id VARCHAR); CREATE TABLE instructor (id VARCHAR) -- Find the id of instructors who didn't teach any courses? SELECT id FROM instructor EXCEPT SELECT id FROM teaches CREATE TABLE teaches (name VARCHAR, id VARCHAR, semester VARCHAR); CREATE TABLE instructor (name VARCHAR, id VARCHAR, semester VARCHAR) -- Find the names of instructors who didn't each any courses in any Spring semester. SELECT name FROM instructor WHERE NOT id IN (SELECT id FROM teaches WHERE semester = 'Spring')