Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester.
A. SELECT DISTINCT course id FROM SECTION WHERE semester = ’Fall’ AND YEAR= 2009 AND course id NOT IN (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010);
B. SELECT DISTINCT course_id FROM instructor WHERE name NOT IN (’Fall’, ’Spring’);
C. (SELECT course idFROM SECTIONWHERE semester = ’Spring’ AND YEAR= 2010)
D. SELECT COUNT (DISTINCT ID. FROM takesWHERE (course id, sec id, semester, YEAR) IN (SELECT course id, sec id, semester, YEARFROM teachesWHERE teaches.ID= 10101);
Answer:A
Which of the following should be used to find all the courses taught in the Fall 2009 semester but not in the Spring 2010 semester.
A. SELECT DISTINCT course id FROM SECTION WHERE semester = ’Fall’ AND YEAR= 2009 AND course id NOT IN (SELECT course id FROM SECTION WHERE semester = ’Spring’ AND YEAR= 2010); B. SELECT DISTINCT course_id FROM instructor WHERE name NOT IN (’Fall’, ’Spring’); C. (SELECT course idFROM SECTIONWHERE semester = ’Spring’ AND YEAR= 2010) D. SELECT COUNT (DISTINCT ID. FROM takesWHERE (course id, sec id, semester, YEAR) IN (SELECT course id, sec id, semester, YEARFROM teachesWHERE teaches.ID= 10101);