Yurttas/PL/DBL/mysql/F/01/00/Company-A/q09.sql

 1/*
 2REM
 3REM q09.sql
 4REM
 5REM Find the names and the addresses of employees who work
 6REM on at least one project located in 'Houston' but whose
 7REM department has no location in 'Houston'.
 8REM
 9*/
10
11\. set-db.sql
12
13SELECT DISTINCT fname, lname, address, dno
14FROM Employee, WorksOn, Project, DeptLocation
15WHERE ssn = essn
16  AND pno = pnumber
17  AND plocation = 'Houston'
18  AND dno = dnumber
19  AND dlocation <> 'Houston';