I need the following SQL queries (I provide a screenshot of the tables and a screenshot that has the instructions of what's needed and how the answer should look like):
LNAME SSN BDATE Smith EMPLOYEE FNAME MINIT John B Franklin Alicia J Jennifer S Ramesh Joyce A Ahmad V James E Wong Zelaya Wallace Narayan English Jabbar Borg 123456789 333445555 999887777 987654321 666884444 453453453 987987987 888665555 1965-01-09 1955-12-08 1968-07-19 1941-06-20 1962-09-15 1972-07-31 1969-03-29 1937-11-10 ADDRESS 731 Fondren, Houston, TX 638 Voss, Houston, TX 3321 Castle, Spring, TX 291 Berry, Bellaire, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX SEX SALARY M 30000 M 40000 F 25000 F 43000 M 38000 F 25000 M 25000 M 55000 SUPERSSN DNO 333445555 5 888665555 5 987654321 4 888665555 4 4 333445555 5 333445555 5 987654321 4 null 1 DEPT_LOCATIONS DNUMBER 1 4 DLOCATION Houston Stafford Bellaire Sugarland Houston DEPARTMENT 5 5 DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445555 987654321 888665555 MGRSTARTDATE 1988-05-22 1995-01-01 1981-06-19 5 WORKS ON PROJECT PNUMBER PLOCATION DNUM 5 1 2 5 ESSN 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 PNO HOURS 1 32.5 2 7.5 3 40.0 1 20.0 2 20.0 2 10.0 3 10.0 10 10.0 20 10.0 30 30.0 10 10.0 10 35.0 30 5.0 30 20.0 20 15.0 20 null PNAME ProductX ProductY Productz Computerization Reorganization Newbenefits 3 Bellaire Sugarland Houston Stafford Houston Stafford 5 4 10 20 1 30 4 DEPENDENT ESSN DEPENDENT NAME SEX BDATE RELATIONSHIP Alice Theodore F M F 333445555 333445555 333445555 987654321 123456789 123456789 123456789 Joy DAUGHTER SON SPOUSE SPOUSE 1986-04-05 1983-10-25 1958-05-03 1942-02-28 1988-01-04 1988-12-30 1967-05-05 Abner Michael Alice Elizabeth SON M F F DAUGHTER SPOUSE qi.sql [20] /* Company database Need Query for this List the location(s) of the department where the employee with 'Michael' as a dependent, works for. Result: (3 rows) DLocation ---- Bellaire Houston Sugarland This should be the answer to the query */ =============== q2.sql [30] /* Company database Need Query for this List the last name of the manager for the project Computerization' along with the number of work assignments for this project. Result: (1 row) LNAME Projects ----- ---- This should be the answer to the query Wallace 3 */ ====EEEEEEEEEEE q3.sql [25] /* Company database Need Query for this List the name of project(s) managed by the 'Research' department with the total number of work hours assigned to each of these projects. Result: (1 row) PNAME Total Hours This should be the answer to the query Productx ProductY Productz 52.5 37.5 50.0 ============ q4.sql [25] /* Company database Need Query for this List the last name(s) of employees supervised by the manager of 'Headquarters' department. and the number of subordinates for each of these employees. Result: (2 rows) LNAME Subordinates This should be the answer to the query Wong Wallace 3 2 ======= ============
