Find the first names and offices of all professors sorted by alphabetical order of their 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
first names of all professors refers to emp_fname from employee table; offices of all professors refers to prof_office from professor table; sorted by alphabetical order of their first name refers to ORDER BY emp_fname; joining of professor and employee table on a common attribute emp_num.