instruction: Show me a bar chart for what is the total credit does each department offer?, and show total number in asc order.
response: SELECT DEPT_CODE, SUM(CRS_CREDIT) FROM COURSE GROUP BY DEPT_CODE ORDER BY SUM(CRS_CREDIT)