how many employees there
select count ( * ) from employee
how many English professors there
select count ( * ) from professor where dept_code = "ENG"
what is the prof high degree of department HIST
select prof_high_degree from professor where dept_code = "HIST"