Task: Text to Code
Input (English): What are the names of students and their respective departments, ordered by number of credits from least to greatest?
Output (English): SELECT name ,  dept_name FROM student ORDER BY tot_cred