instruction: Find the number of professors in each office with a bar chart, show by the x axis in asc please.
response: SELECT PROF_OFFICE, COUNT(PROF_OFFICE) FROM PROFESSOR AS T1 JOIN EMPLOYEE AS T2 ON T1.EMP_NUM = T2.EMP_NUM GROUP BY PROF_OFFICE ORDER BY PROF_OFFICE