แสดงจำนวนหลักสูตรสำหรับผู้สอนแต่ละคนในแผนภูมิแท่ง คุณช่วยเรียงลำดับจำนวนทั้งหมดจากต่ำไปสูงได้ไหม ไม่จำเป็นต้องใช้ตารางทั้งหมด
Show the number of courses for each instructor in a bar chart, could you sort total number from low to high order please?It is not neccessary to use all the tables.
 STUDENT:  STU_NUM [ int]  STU_LNAME [ varchar(15)]  STU_FNAME [ varchar(15)]  STU_INIT [ varchar(1)]  STU_DOB [ datetime]  STU_HRS [ int]  STU_CLASS [ varchar(2)]  STU_GPA [ float(8)]  STU_TRANSFER [ numeric]  DEPT_CODE [ varchar(18)]  STU_PHONE [ varchar(4)]  PROF_NUM [ int] 
SELECT EMP_FNAME, COUNT(EMP_FNAME) 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 EMP_FNAME ORDER BY COUNT(EMP_FNAME)