instruction: What is the average of credit value of courses with more than one prerequisite for each title? Return a bar chart, rank by the total number in descending.
response: SELECT title, AVG(credits) FROM course AS T1 JOIN prereq AS T2 ON T1.course_id = T2.course_id GROUP BY title ORDER BY AVG(credits) DESC