Question: Assignment 2 Retrieve Data from a Single Table This assignment intends to help you understand data insertion and retrieval. To do this assignment, you have

Assignment 2 Retrieve Data from a Single Table This assignment intends to help you understand data insertion and retrieval. To do this assignment, you have to insert all the data into each database table first. Once you complete this job, please write SQL queries for each question below. 1. Retrieve Joyce A. English's SSN 2. Retrieve employees' first name, middle initial, and last name who were born after 1960. 3. Retrieve employees' SSN who works more than 20 hours 4. Retrieve Franklin T. Wong's son's name 5. Retrieve Project names which the research department controls Due date: By 11:59PM, 2/16/2019 Submission file format: Your LastName_Assignment2.sql SEX Employee FNAME MINIT LNAME John Smith Franklin T Wono Jovce A Enolish Remesh K Naravan James E Bora Jennifer S Wallace Ahmad v Jabbar NULL Allda 2 MULL Zelava SSN 123456789 333445555 453453453 666894444 888665555 987654321 987987987 999887777 DOB 1965-01-09 1955-12-08 1972-07-31 1962-09-15 1937-11-10 1941-06-20 1969-03-29 1968-01-19 AL ADORESS 731 Fondren. Houston, TX M 638 Voss Houston, TX 5631 Rice. Houston, TX 975 Fre Oak. Humble. TX 450 Stone. Houston, TX 291 Berrv. Belaire. TX F 980 Dalas. Houston, TX 3321 Castle. Sorina. TX M F M M SALARY DEPARTMENT_DNUMBER 3 0000 5 40000 25000 38000 5 55000 1 43000 25000 25000 NULL LL EMPLOYEE SSN 333445555 888665555 987654321 888665555 333445555 333445555 987654321 M F HULL MULE Department DNAME DNUMBER Headouarters 1 Administration Research MGRSTARTDATE 1981-06-19 1995-01-01 1988-05-22 EMPLOYEE SSN 888665555 987654321 333445555 Dept Locations DLOCATION DEPARTMENT_DNUMBER Houston Stafford Bellaire Suoarland Houston PNUMBER DEPARTMENT_DNUMBER Project PNAME Products Product Productz Computerization Reorganization Newbenefits Works_on HOURS PROJECT PNUMBER PLOCATION Bellaire Suaarland Houston Stafford Houston Stafford 32.5 7.5 10 20 30 EMPLOYEE SSN 123456789 123456789 666884444 453453453 453453453 333445555 333445555 333445555 Dependent DEPENDENT NAME SEX Alice F Theodore M DOS 1986-04-05 1983-10-25 1998-05-03 RELATIONSHIP Daughter Son MULL Spouse EMPLOYEE SSN 333445555 333445555 333445555
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
