SELECT name ,  dept_name FROM student ORDER BY tot_cred
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
select name , dept_name from student order by tot_cred
Find the name of the students and their department names sorted by their total credits in ascending order .