Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this question is the continuous of Golden Glory Project G. Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked

this question is the continuous of Golden Glory Project

G. Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked on a property in Seattle. Use a subquery.

H. Answer question G but use a join using JOIN ON syntax. What are the consequences of using (or not using) the DISTINCT keyword in this version of the query?

I. Write an SQL statement to list LastName, FirstName, and CellPhone of employees who have worked on a property owned by a corporation. Use a subquery.

J. Answer question I but use a join using JOIN ON syntax. What are the consequences of using (or not using) the DISTINCT keyword in this version of the query?

K. Write an SQL statement to show the LastName, FirstName, CellPhone, and sum of hours worked for each employee.

L. Write an SQL statement to show the sum of hours worked for each ExperienceLevel of EMPLOYEE. Sort the results by ExperienceLevel, in descending order.

M. Write an SQL statement to show the sum of HoursWorked for each type of OWNER but exclude services of employees who have ExperienceLevel of Junior.

N. Write an SQL statement to modify all EMPLOYEE rows with ExperienceLevel of Master to SuperMaster.

O. Write SQL statements to switch the values of ExperienceLevel so that all rows currently having the value Junior will have the value Senior and all rows currently having the value Senior will have the value Junior. (Hint: Use the value Unknown as a temporary third value.)

P. Given your assumptions about cascading deletions in your answer to part B, write the fewest number of DELETE statements possible to remove all the data in your database but leave the table structures intact. Do not run these statements if you are using an actual database!

I already posted the data for this questions to previous questions thank you for your help please include explanations.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost Accounting Planning And Control

Authors: Adolph Matz, Milton F. Usry

10th Edition

0538809256, 978-0538809252

More Books

Students also viewed these Accounting questions

Question

Is he a caustic coworker and if so what can be done with him?

Answered: 1 week ago