Database: company_1
Question: 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'