What are the titles of courses offered in the Fall of 2010?
select t1.title from course as t1 join section as t2 on t1.course_id = t2.course_id where semester = 'Fall' and year = 2010
Of these, which were offered in Chandler building?
select t1.title from course as t1 join section as t2 on t1.course_id = t2.course_id where building = 'Chandler' and semester = 'Fall' and year = 2010