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 AS T1 JOIN employee AS T2 ON T1.emp_num  =  T2.emp_num ORDER BY T2.emp_fname
[{'EMP_FNAME': 'Anne', 'PROF_OFFICE': 'BBG 185'}, {'EMP_FNAME': 'Annelise', 'PROF_OFFICE': 'AAK 201'}, {'EMP_FNAME': 'Arnelle', 'PROF_OFFICE': 'KLR 229D'}, {'EMP_FNAME': 'Carlos', 'PROF_OFFICE': 'KLR 300'}, {'EMP_FNAME': 'Doreen', 'PROF_OFFICE': 'KLR 284'}, {'EMP_FNAME': 'George', 'PROF_OFFICE': 'AAK 230'}, {'EMP_FNAME': 'Gerald', 'PROF_OFFICE': 'KLR 211'}, {'EMP_FNAME': 'Herman', 'PROF_OFFICE': 'AAK 297'}, {'EMP_FNAME': 'Hermine', 'PROF_OFFICE': 'AAK 194'}, {'EMP_FNAME': 'Ismael', 'PROF_OFFICE': 'KLR 244'}, {'EMP_FNAME': 'James', 'PROF_OFFICE': 'DRE 156'}, {'EMP_FNAME': 'Melanie', 'PROF_OFFICE': 'KLR 333'}, {'EMP_FNAME': 'Peter', 'PROF_OFFICE': 'KLR 203E'}, {'EMP_FNAME': 'Preston', 'PROF_OFFICE': 'DRE 102'}, {'EMP_FNAME': 'Ralph', 'PROF_OFFICE': 'KLR 284'}, {'EMP_FNAME': 'Robert', 'PROF_OFFICE': 'DRE 102'}, {'EMP_FNAME': 'Robert', 'PROF_OFFICE': 'BBG 208'}, {'EMP_FNAME': 'Ronald', 'PROF_OFFICE': 'DRE 156'}, {'EMP_FNAME': 'Ronald', 'PROF_OFFICE': 'DRE 208'}, {'EMP_FNAME': 'Ross', 'PROF_OFFICE': 'KLR 126'}, {'EMP_FNAME': 'Van', 'PROF_OFFICE': 'AAK 160'}, {'EMP_FNAME': 'Willa', 'PROF_OFFICE': 'KLR 409B'}]