What are the first names and office of the professors who are in the history department and have a Ph.D?
SELECT T1.emp_fname ,  T2.prof_office FROM employee AS T1 JOIN professor AS T2 ON T1.emp_num  =  T2.emp_num JOIN department AS T3 ON T3.dept_code  =  T2.dept_code WHERE T3.dept_name  =  'History' AND T2.prof_high_degree  =  'Ph.D.'
first names = emp_fname; office = prof_office; professors in the history department = WHERE dept_name = 'History'; professors who have a Ph.D = prof_high_degree = 'Ph.D.'; joining tables to get information across employee, professor, and department entities.