Find the names of departments that are located in Houston.
CREATE TABLE dept_locations (
    dnumber VARCHAR,
    dlocation VARCHAR
)

CREATE TABLE department (
    dname VARCHAR,
    dnumber VARCHAR
)
SELECT t1.dname FROM department AS t1 JOIN dept_locations AS t2 ON t1.dnumber = t2.dnumber WHERE t2.dlocation = 'Houston'
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 names of departments that are located in Houston. ### Input: CREATE TABLE dept_locations (
    dnumber VARCHAR,
    dlocation VARCHAR
)

CREATE TABLE department (
    dname VARCHAR,
    dnumber VARCHAR
) ### Response: SELECT t1.dname FROM department AS t1 JOIN dept_locations AS t2 ON t1.dnumber = t2.dnumber WHERE t2.dlocation = 'Houston'