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
names of students refers to name; their respective departments refers to dept_name; ordered by number of credits from least to greatest refers to ORDER BY tot_cred ASC;