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)
SELECT name, dept_name FROM student ORDER BY tot_cred
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE student (name VARCHAR, dept_name VARCHAR, tot_cred VARCHAR) Question: Find the name of the students and their department names sorted by their total credits in ascending order. [/INST] SELECT name, dept_name FROM student ORDER BY tot_cred </s>