Find me all employees with the last name 'Heffington'?
select * from employee where emp_lname = 'Heffington'
What are the names of their departments?
select t3.dept_name 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 t1.emp_lname = 'Heffington'
Also, where are their offices located?
select t3.dept_name, 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 t1.emp_lname = 'Heffington'