CREATE TABLE teaches (id VARCHAR(255), semester VARCHAR(255), YEAR VARCHAR(255))
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