Which professors are in charge of ACCT-211?
select distinct * from employee as t1 join class as t2 on t1.emp_num = t2.prof_num where crs_code = "ACCT-211"
What are their first names?
select distinct t1.emp_fname from employee as t1 join class as t2 on t1.emp_num = t2.prof_num where crs_code = "ACCT-211"
Also, what are their date of births?
select distinct t1.emp_fname, t1.emp_dob from employee as t1 join class as t2 on t1.emp_num = t2.prof_num where crs_code = "ACCT-211"