instruction: Return a bar chart on how many classes are held in each department?, and I want to sort in desc by the Y-axis.
response: SELECT DEPT_CODE, COUNT(*) FROM CLASS AS T1 JOIN COURSE AS T2 ON T1.CRS_CODE = T2.CRS_CODE GROUP BY DEPT_CODE ORDER BY COUNT(*) DESC