What can you tell me about the biology department?
select * from department where dept_name = "Biology"
What are the first name of all professors in the department?
select t3.emp_fname from professor as t1 join department as t2 on t1.dept_code = t2.dept_code join employee as t3 on t1.emp_num = t3.emp_num where dept_name = "Biology"
What are their last names as well?
select t3.emp_fname, t3.emp_lname from professor as t1 join department as t2 on t1.dept_code = t2.dept_code join employee as t3 on t1.emp_num = t3.emp_num where dept_name = "Biology"