SELECT t1.dname FROM department AS t1 JOIN dept_locations AS t2 ON t1.dnumber  =  t2.dnumber WHERE t2.dlocation  =  'Houston'
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 where t2 . dlocation = value
Find the names of departments that are located in Houston .