แผนภูมิแท่งเกี่ยวกับจำนวนอาจารย์ในแต่ละโรงเรียน และแสดงจากต่ำไปสูงตามแกน Y ไม่จำเป็นต้องใช้ตารางทั้งหมด
A bar chart about how many different professors are there for the different schools?, and show from low to high by the Y-axis.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 SCHOOL_CODE, COUNT(*) FROM DEPARTMENT AS T1 JOIN PROFESSOR AS T2 ON T1.DEPT_CODE = T2.DEPT_CODE GROUP BY T1.SCHOOL_CODE ORDER BY COUNT(*)