Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I have 4 and 5 number 6 is the only one im having issues with. I have to write a SQL query for number 6
I have 4 and 5 number 6 is the only one im having issues with. I have to write a SQL query for number 6 and I am stumped on this question.
EMPLOYEE FNAME MINIT John B Franklin T Alicia J Jennifer S Ramesh Joyce A Ahmad v James E LNAME Smith Wong Zelaya Wallace Narayan English Jabbar Borg SSN 123456789 333445555 999887777 967654321 686884444 453453453 987987987 888665555 BOATE 1965-01-09 1965-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 Bery, Bellaire, TX 975 Fire Oak, Humble, TX 5631 Rice, Houston, TX 980 Dallas, Houston, TX 450 Stone, Houston, TX M M F F M F M M SALARY 30000 40000 25000 43000 38000 25000 25000 55000 SUPERSSN DNO 333445555 5 888605555 5 987654321 4 888665555 4 333445555 5 333445555 5 987654321 4 null 1 DEPT_LOCATIONS DEPARTMENT DNUMBER 1 4 5 5 5 DLOCATION Houston Stafford Bellaire Sugarland Houston DNAME Research Administration Headquarters DNUMBER 5 4 1 MGRSSN 333445556 987654321 888665555 MGRSTARTDATE 1968-05-22 1995-01-01 1981-06-19 WORKS ON PNO 1 2 3 1 2 PROJECT 2 3 ESSN 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 889665555 HOURS 325 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 30.0 10.0 35.0 5.0 20.0 PNAME Product Product Productz Computerization Reorganization Newbenefits 10 PNUMBER 1 2 3 10 20 PLOCATION Bellaire Sugarland Houston Stafford Houston Stafford DNUM 5 5 5 4 20 30 10 10 30 1 4. 30 20 20 15.0 nul DEPENDENT ESSN SEX BDATE RELATIONSHIP 333445555 333445555 333445555 987654321 123456789 123456789 123456789 DEPENDENT NAME Alice Theodore Joy Abner Michael Alice Elizabeth F M F M M F 1986-04-05 1963-10-25 1958-05-03 1942-02-28 1968-01-04 1988-12-30 1967-05-05 DAUGHTER SON SPOUSE SPOUSE SON DAUGHTER SPOUSE F 4. Retrieve the names of department managers whose last name start with 'W"; 5. Find the names and addresses of employees who work on at least one project located in Stafford. 6. List the names of employees who have has dependents and is supervised by 'Franklin WongStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started