CREATE TABLE professor (prof_office VARCHAR2, emp_num VARCHAR2)
CREATE TABLE employee (emp_fname VARCHAR2, emp_num VARCHAR2)

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
SELECT "T2"."emp_fname", "T1"."prof_office" FROM "professor" "T1" JOIN "employee" "T2" ON "T1"."emp_num" = "T2"."emp_num" ORDER BY "T2"."emp_fname"