Question: 2. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. 3. Write an SQL statement

2. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master.

3. Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master and FirstName that begins with the letter J.

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

5. Answer question 4 but use a join using JOIN ON syntax.

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

7. Answer question 6 but use a join using JOIN ON syntax.

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

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

10. 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

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...

1. Explain an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. 2. Explainan SQL statement to list LastName, FirstName, and CellPhone...

1 . Write an SQL statement to list LastName, FirstName, and CellPhone for all employees having an experience level of Master. 2 . Write an SQL statement to list LastName, FirstName, and CellPhone for...

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....

2. Write a SQL statement to list LastName, FirstName, and Phone of the customers who made the purchase with SaleIDs 1, 2, and 3 . Use a join with JOIN ON syntax. 3. Write a SQL statement to show the...

Queen Anne Curiosity Shop M . Write an SQL statement to list LastName, FirstName, and Phone of customers who have purchased an item that has an ItemPrice of $ 5 0 0 or more. Use a subquery. N ....

Queen Anne Curiosity Shop I. Write an SQL statement to list LastName, FirstName, and Phone of the customers who made the purchases with SaleIDs 1 , 2 , and 3 . Use a subquery. J . Answer part I but...

Queen Anne Curiosity Shop O . Write an SQL statement to list LastName, FirstName, and Phone of customers who have purchased an item that was supplied by a vendor with a CompanyName that begins with...

USE Garden_Glory GO CREATE TABLE OWNER( OwnerID Int NOT NULL IDENTITY(1,1), OwnerName Char(50) NOT NULL, OwnerEmailAddress VarChar(100) NULL, OwnerType Char(12) NULL, CONSTRAINT OWNER_PK PRIMARY...

Hello, this is for SQL. Can I get some help with J-R? Thank you! Caci name only ONCE WIIU have all " U lar e Product Number eo product list eact J. Write an SQL statement to list the FirstName,...

REQUIREMENTS Please follow these instructions carefully! 3. Prepare a 6-column worksheet and enter the? December ? 31 ?unadjusted balances from the general ledger ? ? accounts. Also enter adjusting...

An aging analysis on June 30 of the accounts receivable of U-Z Door Corporation indicates that uncollectible accounts amount to $86,000. Prepare the journal entry to record uncollectible accounts...

Canadian CanCom has a cumulative redeemable prelerred share, 7 . 0 % series ( $ 5 0 par value ) outstanding. Last year the company failed to pay any dividends. This year the company has enough funds...

Given that the Share Price is equal to the product of the Earnings per Share and the Price- Earnings Ratio or Multiple, P = EPS x PE, where P = $50 and EPS = $2.00 a. Detail the effect that a 10%...

3. How serious a problem is the new digital divide? Explain your answer. There may be only 11 players on the pitch during a match, but the Blackburn Rovers Football Club in the UK employs more than...

2. Why is access to technology insufficient to eliminate the digital divide? There may be only 11 players on the pitch during a match, but the Blackburn Rovers Football Club in the UK employs more...

3-16 Is there anything else Barnes & Noble and the book publishers should be doing to stimulate more business? Borders Group (including many former Waldenbooks rebranded as Borders Express)...