I'd like to know how many professors have a Ph.D. or MA?
select count ( * ) from professor where prof_high_degree = 'Ph.d.' or prof_high_degree = 'MA'
How many of them are Ph.D. degrees?
select count ( * ) from professor where prof_high_degree = 'Ph.d.'