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'
What is department name and office for the professor whose last name is Heffington?
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 '
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 = value
What is department name and office for the professor whose last name is Heffington ?