Which courses ran in Fall 2009 and in Spring 2010?
select * from section where semester = 'Fall' and year = 2009 intersect select course_id from section where semester = 'Spring' and year = 2010
What building is the Spring 2010 course located?
select building from section where semester = 'Spring' and year = 2010
Section ID
select building from section where sec_id = 443
Which building housed course ID 443?
select building from section where course_id = 443