Database: college_2
Question: Find the name of the students and their department names sorted by their total credits in ascending order.
SQL:
SELECT name ,  dept_name FROM student ORDER BY tot_cred