Find the name of the students and their department names sorted by their total credits in ascending order.
SELECT name ,  dept_name FROM student ORDER BY tot_cred
sorted by their total credits in ascending order refers to ORDER BY tot_cred ASC; name of the students refers to name; their department names refers to dept_name;