What are the first names and office locations for all professors sorted alphabetically by first name?
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