What are the first names of professors in the history department?
SELECT T1.emp_fname from employee as T1 join professor as T2 on T1.emp_num  =  T2.emp_num where T2.dept_code  =  'HIST'
first names of professors = SELECT emp_fname; in the history department refers to dept_code = 'HIST';