instruction: Find the sum of credits of courses that have more than one prerequisites for each department with a bar chart, I want to sort in ascending by the X-axis.
response: SELECT dept_name, SUM(credits) FROM course AS T1 JOIN prereq AS T2 ON T1.course_id = T2.course_id GROUP BY dept_name ORDER BY dept_name