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
first names refer to emp_fname; office locations refer to prof_office; professors are distinguished by being in both employee and professor tables; sorted alphabetically by first name refers to ORDER BY emp_fname ASC; JOIN is used to combine data from professor and employee tables based on matching employee numbers (emp_num).