Database: college_2
Question: Find the id of instructors who taught a class in Fall 2009 but not in Spring 2010.
SQL:
SELECT id FROM teaches WHERE semester  =  'Fall' AND YEAR  =  2009 EXCEPT SELECT id FROM teaches WHERE semester  =  'Spring' AND YEAR  =  2010