Question: Write the following queries in SQL on the Company Database Schema. ( 1 0 points ) 1 Retrieve the SSN , Fname, and Lname of
Write the following queries in SQL on the Company Database Schema. pointsRetrieve the SSN Fname, and Lname of employees who have more than two dependents.Retrieve the SSN Fname, and Lname of employees whose total working hours exceed Retrieve the SSN Fname, and Lname of employees directly supervised by Franklin Wong.Retrieve the SSN Fname, and Lname of department managers who do not have any dependents.Insert a new record into the EMPLOYEE table with the following details: First Name Christopher, Last Name Robin, Middle Initial J SSN Birthdate Address San Jose, San Antonio, TX Gender Male, Salary $ Supervisor SSN and Department Number Insert a new record into the PROJECT table with the following detail: Pname Orange, Pnumber Plocation Humble, and Dnum Delete the record from the WORKSON table where the Employee name James, Lname Borg and the Project Number Delete the record from the DEPTLOCATIONS table where the department name Research and location Houston.Update the Project Name Pname of the PROJECT table from ProjectX to Project X One.Update the Dependentname of the DEPENDENT table to Grace where relationship Daughter, and employee Fname John and Lname Smith.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
