CREATE TABLE dependent (essn DECIMAL, dependent_name TEXT, sex TEXT, bdate TEXT, relationship TEXT)
CREATE TABLE employee (fname TEXT, minit TEXT, lname TEXT, ssn DECIMAL, bdate TEXT, address TEXT, sex TEXT, salary DECIMAL, super_ssn DECIMAL, dno DECIMAL)
CREATE TABLE dept_locations (dnumber DECIMAL, dlocation TEXT)
CREATE TABLE works_on (essn DECIMAL, pno DECIMAL, hours DECIMAL)
CREATE TABLE department (dname TEXT, dnumber DECIMAL, mgr_ssn DECIMAL, mgr_start_date TEXT)
CREATE TABLE project (pname TEXT, pnumber DECIMAL, plocation TEXT, dnum DECIMAL)

Find the names of departments that are located in Houston.
SELECT t1.dname FROM department AS t1 JOIN dept_locations AS t2 ON t1.dnumber = t2.dnumber WHERE t2.dlocation = 'Houston'
SELECT "t1"."dname" FROM "department" AS "t1" JOIN "dept_locations" AS "t2" ON "t1"."dnumber" = "t2"."dnumber" AND "t2"."dlocation" = 'Houston'