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
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the name of the students and their department names sorted by their total credits in ascending order. ### Input: CREATE TABLE student (
    name VARCHAR,
    dept_name VARCHAR,
    tot_cred VARCHAR
) ### Response: SELECT name, dept_name FROM student ORDER BY tot_cred