SELECT T2.emp_fname ,  T1.class_room FROM CLASS AS T1 JOIN employee AS T2 ON T1.prof_num  =  T2.emp_num JOIN professor AS T3 ON T2.emp_num  =  T3.emp_num JOIN department AS T4 ON T4.dept_code  =  T3.dept_code WHERE T4.dept_name  =  'Accounting'
Find the first names of all professors in the Accounting department who is teaching some course and the class room.
SELECT T2.emp_fname , T1.class_room FROM CLASS AS T1 JOIN employee AS T2 ON T1.prof_num = T2.emp_num JOIN professor AS T3 ON T2.emp_num = T3.emp_num JOIN department AS T4 ON T4.dept_code = T3.dept_code WHERE T4.dept_name = 'Accounting '
select t2 . emp_fname , t1 . class_room from class as t1 join employee as t2 on t1 . prof_num = t2 . emp_num join professor as t3 on t2 . emp_num = t3 . emp_num join department as t4 on t4 . dept_code = t3 . dept_code where t4 . dept_name = value
Find the first names of all professors in the Accounting department who is teaching some course and the class room .