CREATE TABLE student (name VARCHAR(255), dept_name VARCHAR(255), tot_cred VARCHAR(255))
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