Find the number of professors in accounting department.
create table professor (dept_code varchar, PRIMARY KEY (dept_code)); create table department (dept_code varchar, PRIMARY KEY (dept_code))
select count(*) from professor as t1 join department as t2 on t1.dept_code = t2.dept_code where dept_name = "accounting"