how many professors there
select count ( * ) from professor
how many English professors there
select count ( * ) from professor where dept_code = "ENG"
yes sir
select dept_code from professor where emp_num = 103