I would like both please!
select * from course as t1 join section as t2 on t1.course_id = t2.course_id where building = 'Chandler'
Thank you for that!  Can you filter that list to show only the rows that correspond to Fall of 2010?
select * from course as t1 join section as t2 on t1.course_id = t2.course_id where building = 'Chandler' and semester = 'Fall' and year = 2010
Can you please tell me how many credits that course was worth?
select credits from course as t1 join section as t2 on t1.course_id = t2.course_id where building = 'Chandler' and semester = 'Fall' and year = 2010