How many professors do have a Ph.D.?
select count(*) from professor where prof_high_degree = 'Ph.d.'
Count the number of these professors for each department.
select count(*), dept_code from professor where prof_high_degree = 'Ph.d.' group by dept_code