How many professors have a Ph.D. in each department?
select count(*), dept_code from professor where prof_high_degree = 'Ph.d.' group by dept_code