what is the first and last name of the profesor in biology department?
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"
how many employee in table?
select count ( * ) from employee
what is the highest professor extension in the table?
select max ( prof_extension ) from professor
what is least employee number in the table?
select min ( emp_num ) from employee