Task: Text to Code
Input (English): SQL: SELECT name , dept_name FROM student GROUP BY dept_name ORDER BY Sum ( tot_cred ) Asc
Feedback: order by course id not by the results of step 1
Output (English): SELECT name ,  dept_name FROM student ORDER BY tot_cred