SELECT id FROM teaches WHERE semester = 'Fall' AND YEAR = 2009 EXCEPT SELECT id FROM teaches WHERE semester = 'Spring' AND YEAR = 2010
Temukan ID instruktur yang mengajar kelas di musim gugur 2009 tetapi tidak pada musim semi 2010.
CREATE TABLE teaches (id VARCHAR, semester VARCHAR, YEAR VARCHAR)