How many departments do you have?
select count ( * ) from department
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'
What are the offices of these professors?
select t2.prof_office from employee as t1 join professor as t2 on t1.emp_num = t2.emp_num where t2.dept_code = 'HIST'
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.'