สำนักงานแต่ละแห่งมีหลักสูตรกี่หลักสูตร? ขอแสดงแผนภูมิแท่ง และแสดงแกน y จากต่ำไปสูง ไม่จำเป็นต้องใช้ตารางทั้งหมด
How many courses for each office? Show me a bar chart, and display y-axis from low to high order please.It is not neccessary to use all the tables.
 EMPLOYEE:  EMP_NUM [ int]  EMP_LNAME [ varchar(15)]  EMP_FNAME [ varchar(12)]  EMP_INITIAL [ varchar(1)]  EMP_JOBCODE [ varchar(5)]  EMP_HIREDATE [ datetime]  EMP_DOB [ datetime] 
SELECT PROF_OFFICE, COUNT(PROF_OFFICE) FROM CLASS AS T1 JOIN EMPLOYEE AS T2 ON T1.PROF_NUM = T2.EMP_NUM JOIN COURSE AS T3 ON T1.CRS_CODE = T3.CRS_CODE JOIN PROFESSOR AS T4 ON T2.EMP_NUM = T4.EMP_NUM GROUP BY PROF_OFFICE ORDER BY COUNT(PROF_OFFICE)