Find the first and last names of all employees that work on a project. Name the query Project Employees.

Transcribed Image Text:

EMPLOYEE Frame Minit Lname John B Smith Franklin T Wong Alicia Jennifer Ramesh Joyce Ahmad James Bdate Address Sex Salary Super_ssn Dno San 123456789 1965-01-09 731 Fondren, Houston, TX 333445555 1955-12-08 638 Voss, Houston, TX M 30000 333445555 M 40000 888665555 J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX English 453453453 1972-07-31 5631 Rice, Houston, TX Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX E Borg 888665555 1937-11-10 450 Stone, Houston, TX SKAVE DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pho Hours 1 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 23 1 2 2 Dnumber 5 4 1 3 288928888 10 20 30 30.0 10.0 10 10 35.0 5.0 30 30 20.0 15.0 20 20 NULL Mgr_ssn 333445555 987654321 888665555 DEPENDENT Essn Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 PROJECT Pname 333445555 333445555 333445555 Joy 987654321 123456789 123456789 123456789 ProductX ProductY ProductZ Computerization Reorganization Newbenefits Dependent name Alice Theodore Abner Michael Alice Elizabeth MFF F M F M 25000 987654321 43000 888665555 38000 333445555 25000 333445555 25000 987654321 M 55000 NULL DEPT LOCATIONS Dnumber 1 2 3 10 20 30 Pnumber 1 4 5 5 5 Plocation Dlocation Houston Stafford Bellaire Sugarland Houston Bellaire Sugarland Houston Stafford Houston Stafford Sex F M F M M 1988-01-04 Son F 1988-12-30 F 1967-05-05 55445 Dnum 5 5 5 4 1 4 5 4 1 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse Daughter Spouse EMPLOYEE Frame Minit Lname John B Smith Franklin T Wong Alicia Jennifer Ramesh Joyce Ahmad James Bdate Address Sex Salary Super_ssn Dno San 123456789 1965-01-09 731 Fondren, Houston, TX 333445555 1955-12-08 638 Voss, Houston, TX M 30000 333445555 M 40000 888665555 J Zelaya 999887777 1968-01-19 3321 Castle, Spring, TX Wallace 987654321 1941-06-20 291 Berry, Bellaire, TX Narayan 666884444 1962-09-15 975 Fire Oak, Humble, TX English 453453453 1972-07-31 5631 Rice, Houston, TX Jabbar 987987987 1969-03-29 980 Dallas, Houston, TX E Borg 888665555 1937-11-10 450 Stone, Houston, TX SKAVE DEPARTMENT Dname Research Administration Headquarters WORKS ON Essn 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 333445555 999887777 999887777 987987987 987987987 987654321 987654321 888665555 Pho Hours 1 32.5 7.5 40.0 20.0 20.0 10.0 10.0 10.0 10.0 23 1 2 2 Dnumber 5 4 1 3 288928888 10 20 30 30.0 10.0 10 10 35.0 5.0 30 30 20.0 15.0 20 20 NULL Mgr_ssn 333445555 987654321 888665555 DEPENDENT Essn Mgr_start_date 1988-05-22 1995-01-01 1981-06-19 PROJECT Pname 333445555 333445555 333445555 Joy 987654321 123456789 123456789 123456789 ProductX ProductY ProductZ Computerization Reorganization Newbenefits Dependent name Alice Theodore Abner Michael Alice Elizabeth MFF F M F M 25000 987654321 43000 888665555 38000 333445555 25000 333445555 25000 987654321 M 55000 NULL DEPT LOCATIONS Dnumber 1 2 3 10 20 30 Pnumber 1 4 5 5 5 Plocation Dlocation Houston Stafford Bellaire Sugarland Houston Bellaire Sugarland Houston Stafford Houston Stafford Sex F M F M M 1988-01-04 Son F 1988-12-30 F 1967-05-05 55445 Dnum 5 5 5 4 1 4 5 4 1 Bdate Relationship 1986-04-05 Daughter 1983-10-25 Son 1958-05-03 Spouse 1942-02-28 Spouse Daughter Spouse

Answer rating: 100% (QA)

Sql SELECT EmployeesFirstName EmployeesLastName ... View the full answer