Question: 1. Write SQL Statements to insert at least three rows of data into each of these above tables. Assume that any surrogate key value will

  • 1. Write SQL Statements to insert at least three rows of data into each of these above tables. Assume that any surrogate key value will be supplied by the DBMS as described above.
  • 2. Write a SQL Statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master and LastName that begins with the letter J. (Change LastName to display 'Last Name' and FirstName to display 'First Name' and CellPhone to display 'Cell').
  • 3. Write a SQL Statement to list the LastName and FirstName of employees who have worked on a property in Seattle. Use a SUBQUERY only.
  • 4. Write a SQL Statement to list the LastName and FirstName of employees who have worked on a property owned by a Corporation. Use a JOIN only.
  • 5. Write a SQL Statement to show the name and sum of hours worked for each employee.
  • 6. Write a SQL Statement to modify all EMPLOYEE rows with ExperienceLevel of Master to SuperMaster.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Well assume you have the following tables structured appropriately for the context EMPLOYEE EmployeeID LastName FirstName ExperienceLevel CellPhone PR... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!