EMPLOYEE(SSN, NAME, SEX, DNUMBER)
DEPARTMENT(DNUMBER, DNAME, DMGRSSN)
DLOCATION(DNUMBER, DLOCATION)
PROJECT(PNUMBER, PNAME, PLOCATION)
WORKSON(SSN, PNUMBER, HOURS)
Write the following queries in SQL:
1. List the name(s) of employee(s) who works(work) on every project located in 'Houston.'
2. List the name(s) of employee(s) who only works(work) on every project located in 'Houston.'
3. List the name(s) of employee(s) who works(work) on every project except the one(s) located in Houston.
4. List name(s) of employee(s) who works(work) on exactly all projects located in 'Houston.