How many professors are there?
select count(*) from professor
How many of them are there for each school?
select count(*), t1.school_code from department as t1 join professor as t2 on t1.dept_code = t2.dept_code group by t1.school_code