Who are all professors?
select * from professor
What about those who have a Ph.D. degree.
select * from professor where prof_high_degree = 'Ph.d.'
How many of them are there?
select count(*) from professor where prof_high_degree = 'Ph.d.'