What is all the information about the history department?
select * from department where dept_name = 'History'
What are the names of professors in this department?
select t1.emp_lname from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num join department as t3 on t2.dept_code = t3.dept_code where t3.dept_name = 'History'
Also, where are their offices located?
select t1.emp_lname, t2.prof_office from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num join department as t3 on t2.dept_code = t3.dept_code where t3.dept_name = 'History'