Order the employees alphabetically by first name
select * from employee order by emp_fname
Which of those are professors?
select * from professor as t1 join employee as t2 on t1.emp_num = t2.emp_num order by t2.emp_fname
What are their first names and office locations?
select t2.emp_fname, t1.prof_office from professor as t1 join employee as t2 on t1.emp_num = t2.emp_num order by t2.emp_fname