yes
select id from teaches where semester = 'Fall' and year = 2009
Retain the instructor IDs who did not teach in Spring 2010 but did teach in Fall 2009
select id from teaches where semester = 'Fall' and year = 2009 except select id from teaches where semester = 'Spring' and year = 2010