What are the ids for courses offered in the Fall of 2009?
select course_id from section where semester = 'Fall' and year = 2009
Of these, which were also offered in the Spring of 2010?
select course_id from section where semester = 'Fall' and year = 2009 intersect select course_id from section where semester = 'Spring' and year = 2010