What is the school code for the accounting department?
select school_code from department where dept_name = 'Accounting'
What is the accounting department's address?
select dept_address from department where dept_name = 'Accounting'
Where is the professor of accounting's office?
select t3.prof_office from professor as t3 join department as t4 on t4.dept_code = t3.dept_code where t4.dept_name = 'Accounting'
What degree does the professor of account hold?
select t3.prof_high_degree from professor as t3 join department as t4 on t4.dept_code = t3.dept_code where t4.dept_name = 'Accounting'
Where is the classroom located?
select 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 t1.crs_code = "ACCT-211" and t1.class_time like '%t%'