instruction: Find the total credits of all classes offered by each department Visualize by bar chart, and could you order in desc by the DEPT_CODE?
response: SELECT DEPT_CODE, SUM(T1.CRS_CREDIT) FROM COURSE AS T1 JOIN CLASS AS T2 ON T1.CRS_CODE = T2.CRS_CODE GROUP BY T1.DEPT_CODE ORDER BY DEPT_CODE DESC