CREATE TABLE dept_locations (dnumber VARCHAR2, dlocation VARCHAR2)
CREATE TABLE department (dname VARCHAR2, dnumber VARCHAR2)

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" "t1" JOIN "dept_locations" "t2" ON "t1"."dnumber" = "t2"."dnumber" AND "t2"."dlocation" = 'Houston'