Hello!  How many students are enrolled in the class with the course code of ACCT-211?
select count ( * ) from class as t1 join enroll as t2 on t1.class_code = t2.class_code where t1.crs_code = 'ACCT-211'
Excellent!  Can you show the class time and class room for ACCt-211?
select class_time,class_room from class where crs_code = 'ACCT-211'
Thank you!  I thought there might be more to that table...  Can you provide me with a list of all of the different course codes?
select distinct crs_code from class