Write as a mysql statement

From the company database, find the names and addresses of employees who work on at least one project located in Houston but whose department has no location in Houston. EMPLOYEE Minit Lname Ssn Bdate Sex Salary Super ssr Address Dro Fname DEPARTMENT Dname Dnumber Mgr ssn Mgr start date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn PnoHours Figure Schema DEPENDENT COMPA Essn Dependent name Sex Bdate Relationship databas 162 Chapter 5 The Relational Data Model and Relational Database Constraints Figure 5.6 One possible database state for the COMPANY relational database schema. EMPLOYEE Sex Salary Fname Ssn Minit Lname Bdate Address Super_ssn Dno 30000 333445555 1965-01-09 731 Fondren, Houston, TX M 333445555 1955-12-08 638 Voss, Houston, TX John Smith 123456789 5 40000 888665555 Franklin Wong M 5 1968-01-19 3321 Castle, Spring, TX 25000 98765 4321 J Alicia Zelaya 999887777 E 4 Wallace 987654321 43000 888665555 Jennifer 1941-06-20 291 Berry, Bellaire, TX E 4 Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX M Ramesh K 38000 333445555 5 Joyce A English 25000 333445555 453453453 1972-07-31 5631 Rice, Houston, TX P 5 1969-03-29 980 Dallas, Houston, TX Ahmad Jabbar 25000 98765 4321 V 987987987 M 4 55000 NULL James Borg 1937-11-10 450 Stone, Houston, TX M 888665555 1 DEPARTMENT DEPT LOCATIONS Dnumber Dlocation Dnumber Mgr_start_date Dname Mgr ssn 1 Research Houston 5 333445555 1988-05-22 4 987654321 Administration Stafford 1995-01-01 5 Headquarters 1 888665555 1981-06-19 Bellaire Sugarland Houston 5 WORKS ON PROJECT Essn Pno Pnumber Hours Plocation Dnum Pname 32.5 ProductX Bellaire 123456789 1 123456789 Producty 5 2 7.5 Sugarland 2 3 ProductZ Houston 666884444 40.0 3 5 Computerization 453453453 1 Stafford 4 20.0 10 Reorganization 453453453 2 Houston 20.0 20 1 Newbenefits 333445555 2 Stafford 30 10.0 10.0 333445555 333445555 10.0 10 DEPENDENT 333445555 20 10.0 Dependent name Essn Sex Bdate Relationship 999887777 30 30.0 Daughter 333445555 Alice 1986-04-05 999887777 10 10.0 Theodore M Son 333445555 1983-10-25 10 35.0 987987987 Joy Abner Spouse 333445555 1958-05-03 5.0 987987987 30 M Spouse 987654321 1942-02-28 30 987654321 20.0 M Michael Son 123456789 1988-01-04 987654321 15.0 20 Alice Daughter 123456789 1988-12-30 Elizabeth NULL Spouse 888665555 20 123456789 1967-05-05

"Get 15% discount on your first 3 orders with us"
Use the following coupon
"FIRST15"

Order Now