Both, please
select t2.emp_fname, t2.emp_lname from professor as t1 join employee as t2 on t1.emp_num = t2.emp_num order by t2.emp_fname
Where are their offices, if you don't mind?
select t1.prof_office from professor as t1 join employee as t2 on t1.emp_num = t2.emp_num order by t2.emp_fname
What are all of their professor high degree?
select prof_high_degree from professor