CREATE TABLE dept_locations (dnumber VARCHAR(255), dlocation VARCHAR(255)); CREATE TABLE department (dname VARCHAR(255), dnumber VARCHAR(255))
Find the names of departments that are located in Houston.
    
SQL: SELECT t1.dname FROM department AS t1 JOIN dept_locations AS t2 ON t1.dnumber = t2.dnumber WHERE t2.dlocation = 'Houston'