Database: college_2
Question: What are the ids for courses that were offered in both Fall of 2009 and Spring of 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