Database: college_2
Question: What are the names of students and their respective departments, ordered by number of credits from least to greatest?
SQL:
SELECT name ,  dept_name FROM student ORDER BY tot_cred