How many different professors are there for the different schools?
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