instruction: Bar chart of total number of credits from each dept name, and show from high to low by the total number of credits.
response: SELECT dept_name, SUM(credits) FROM course GROUP BY dept_name ORDER BY SUM(credits) DESC