Can you tell me the first name and office of the professor in the history department who has a Ph.D. degree?
SELECT T1.emp_fname, T2.prof_office from employee as T1 join professor as T2 on T1.emp_num  =  T2.emp_num where T2.dept_code  =  'HIST' and T2.PROF_HIGH_DEGREE  =  'Ph.D.'
first name = emp_fname; office = prof_office; professor in the history department = dept_code = 'HIST'; has a Ph.D. degree = PROF_HIGH_DEGREE = 'Ph.D.';