instruction: What is the sum of credit value of courses with more than one prerequisite for each department? Return a bar chart, I want to show y-axis from low to high order.
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 SUM(credits)