Tell me class code for class room BUS311 ?
select class_code from class where class_room = 'BUS311'
Tell me professor employee number for course code ACCT-211 ?
select prof_num from class where crs_code = 'ACCT-211'
Tell me the class time for class section 3 ?
select class_time from class where class_section = 3
Find the number of classes offered for all class rooms that held at least 2 classes ?
select count ( * ), class_room from class group by class_room having count ( * ) > = 2