SQL

1. Retrieve the first names and last names of employees in Department 5 who work more than 10 hours per week on the 'ProductX' project.
2. List the names of employees who have a dependent with a different first name as themselves.
3. Find the names of employees that are directly supervised by 'Franklin Wong'.
4. Provide the first name and last name of John Smiths supervisor.
5. Find the first name and last name of the managers of all the departments.
6. List the names of all the males who are dependents of employees who work in the 'Research' department.

rougn EMPLOYEE FnameMinitLname Ssn Bdate Address Sex Salary Super ssn Dno B Smith 123456789 1965-01-09 731 Fondren, Houston, TX M 30000 333445555 5 Franklin T Wong 333445555 1955-1208 638 Voss, Houston, TX M 40000 888665555 AliciaJZelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 JenniferS Wallace 987654321 1941-06-20 291 Berry, Bellaire, TXF 43000 888665555 4 RameshK 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 Borg888665555 1937-11-10 450 Stone, Houston, TX M 55000 NULL DEPARTMENT DEPT LOCATIONS Dnumber umber Dlocation Research Administration Headquarters gr ssn 333445555 987654321 888665555 Mgr start date 1988-05-22 1995-01-01 1981-06-19 Houston Stafford Bellaire Sugarland Houston WORKS ON PROJECT Pno Pnumber Plocation Dnum Hours 32.5 7.5 ProductX ProductY Productz Computerization 10 Reorganization20 Houston Newbenefits 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 10 10.0 333445555 20 10.0 999887777 999887777 10 10.0 987987987 987987987 987654321 987654321 888665555 20 NULL Bellaire 2 Sugarland 20.0 20.0 2 10.0 3 10.0 Stafford 30 Stafford DEPENDENT Essn 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 Abner 23456789 Michael 123456789 Alice 123456789 Elizabeth Dependent name S Bdate Relationship 30 30.0 10 35.0 30 30 20.0 20 15.0 F 19804-05 Daughter M 1983-10-25 Son F 1958-05-03 Spouse M 1942-02-28 Spouse M 1988-01-04 Son F 1988-12-30 Daughter 5.0 F 1967-05-05 Spouse