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