Write sql queries


Write the following queries in SQL: 

1.If an employee works on every project located in Houston, then list the employees social security number and name.

2.If an employee works on only the project(s) located in Houston, then list the employees social security number and name.

3.If an employee works on every project except the one(s) controlled by the department that has no location in Houston, then list the employees social security number and name.

4.If an employee works on exactly all projects located in Houston, then list the employees social security number and name.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write sql queries
Reference No:- TGS0120940

Expected delivery within 24 Hours