SQL queries

For each project, list its project number along with the SSNs and names of employees working on it.

For each employee, list his/her name, and the name(s) of project(s) they work on.

For each department manager, list his/her name along with the names of employees they supervise.

For each project, list the project name and the number of employees working on it.

For each project, list its project number along with the SSNs of employees working on it.

EMPLOYEE Dno Fname Mint Lname John B Smith123456789 1965-01-09 731 Fondren, Houston, TX M 30000 3334455555 FranklinT Wong 333445555 1955-12-08 638 Voss, Houston, TX M 40000 8886655555 Alicia Bdate Address Sex Salary Super ssn J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX F 25000 987654321 4 Jennifer S Wallace 987654321 1941-06-20 291 Berry, Bellaire, TXF 43000 888665555 4 ameshKNarayan 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 DEPARTMENT DEPT LOCATIONS Dnumber Dlocation Dname Research Admin Headquarters 333445555 987654321 888665555 Mgr start_date 1988-05-22 995-01-01 981-06-19 5 Sugarland 5 WORKS ON PROJECT Pno Pnumber Plocation Dnum Hours 32.5 7.5 40.0 20.0 ProductX ProductY ProductZ Computerization Reorganizati Newbenef 23456789 23456789 666884444 453453453 453453453 333445555 333445555 33445555 10 10.0 333445555 20 999887777 999887777 987987987 987987987 987654321 987654321 5 2 Sugarland5 5 3 Houston 10 Stafford 20 Houston 30 Stafford 2 20.0 10.0 3 10.0 DEPENDENT Essn 333445555 Alice 333445555 Theodore 333445555 Joy 987654321 123456789 Michael 23456789 Alice Dependent name Sex Bdate 30 10 10.0 10 35.0 30 30 20.0 20 15.0 30.0 F 1986-04-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 F 1967-05-05 Spouse 5.0 88866555520 NULL 123456789 Eizabeth