Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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