how many instructors have taught ACCT-211?
select count ( distinct prof_num ) from class where crs_code = "ACCT-211"
can you tell me their first names and offices, please?
select emp_fname, prof_office from class as t1 join employee as t2 on t1.prof_num = t2.emp_num join course as t3 on t1.crs_code = t3.crs_code join professor as t4 on t2.emp_num = t4.emp_num where t1.crs_code = "ACCT-211"
excellent. can you also give me the course description for ACCT-211?
select crs_description from course where crs_code = "ACCT-211"