Find the number of professors in accounting department.
SELECT count(*) FROM professor AS T1 JOIN department AS T2 ON T1.dept_code  =  T2.dept_code WHERE DEPT_NAME  =  "Accounting"
number of professors in accounting department refers to COUNT(professor.id) where department is 'Accounting'; joining tables professor and department on department code (dept_code);