How many professors have either a Ph.D. or a MA degree?
select count ( * ) from professor where prof_high_degree = 'Ph.d.' or prof_high_degree = 'MA'
Show me employee number for professors with a Ph.D. degree
select emp_num from professor where prof_high_degree = 'Ph.d.'
Show me professor office for professors with a MA degree
select prof_office from professor where prof_high_degree = 'MA'