Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 Wong

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Azure SQL Database For Modern Developers Building Applications In The Microsoft Cloud

Authors: Davide Mauri, Silvano Coriani, Anna Hoffma, Sanjay Mishra, Jovan Popovic

1st Edition

1484263693, 978-1484263693

More Books

Students also viewed these Databases questions

Question

Formal evaluation criteria that limit managerial discretion

Answered: 1 week ago