Find the name of the students and their department names sorted by their total credits in ascending order.
CREATE TABLE student (name VARCHAR, dept_name VARCHAR, tot_cred VARCHAR)
[SQL] SELECT name, dept_name FROM student ORDER BY tot_cred [/SQL]