What is the number of professors for different 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