SQL:

a) Retrieve the names of all employees whose supervisor has 888665555 for SSN.

b) Retrieve the names of all employees who work in the department that has the employee with the highest salary among all employees.

c) Find the SSNs of department managers who dont have dependents.

Thank you in advance!

EMPLOYEE Frame Minit Lname ssn Bdate Address Sex Salary Super-ssn Dino John B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Franklin T Wong 333445555 1955-12-08 638 Voss, Houston, TX LM 40000 888665555 5 Alicia J Zelaya 999887777 1968.01-19 3321 Castle, Spring, TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX F 43000 B88665555 4 Ramesh K Narayan 666884444 1962.09.15 975 Fire Oak, Humble, TX M 38000 333445555 5 Joyce A English 453453453 1972-07-31 5631 Rice, Houston, TX F 25000 333445555 5 Ahmad v Jabbar 987987987 1969-03-29 980 Dallas, Houston, Tx M 25000 987654321 4 James E Borg 888665555 1937. 11.10 450 Stone, Houston, TX M 55000 NULL 1 DEPARTMENT DEPT LOCATIONS Dname Dnumber Mgr ssn Dnumber Dlocation Mgr start date 1 5 333445555 1988-05-22 Research Houston 4 4 Stafford 987654321 1995-01-01 Administration 1 5 888665555 1981-06-19 Bellaire Headquarters 5 Sugarland 5 Houston