Database: college_2
Question: Find courses that ran in Fall 2009 and in Spring 2010.
SQL:
SELECT course_id FROM SECTION WHERE semester  =  'Fall' AND YEAR  =  2009 INTERSECT SELECT course_id FROM SECTION WHERE semester  =  'Spring' AND YEAR  =  2010