Question: SQL Activity Result 1 Write a query that will return the following information: Total Sales each employee made First Name and Last Name of Employee

SQL Activity Result 1 Write a query that will return the

SQL

Activity Result 1 Write a query that will return the following information: Total Sales each employee made First Name and Last Name of Employee . 2 . 3 Total Sales is Unit Price*Quantity in the Order Details Table and discount should be included (%) 4 FirstName LastName TotalSales Michael Suyama 73913,1292438507 Margaret Peacock 232890,845947266 Janet Leverling 202812,842793465 Andrew Fuller 166537,75497818 Nancy Davolio 192107,604320526 Steven Buchanan 68792,2825393677 Laura Callahan 126862,277704239 Anne Dodsworth 77308,0667095184 Robert King 124568,23538208 5 6 7 8 9

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!

Write SQL commands for the following requirements. ( 1 ) Write a query to list visit number, visit date, doctor ID , patient number, patient name, and pat balance from those visit records in the...

Creating Queries using SQL SSB would like for you to generate several queries using the SQL "Query Design" feature in Access. The queries are designed to provide an overview of the data stored in the...

/ * Create department table * / CREATE TABLE department ( dpt _ no INT PRIMARY KEY, dpt _ name VARCHAR ( 2 0 ) NOT NULL, dpt _ mgrssn CHAR ( 9 ) , dpt _ mgr _ start _ date DATE ) ; / * Create dept _...

This SQL question involves writing SELECT and DML statements involving a single table. The SQL should be written using the standard coding style: all keywords are to be in upper case all user-defined...

1. Write the SQL query to retrieve the following information of all employees: a. Employee number b. Employeelastname c. Date of hire d. Jobcode. The company wants to send a check to their employees...

Please write down again and make sure which sentence corrects which line? Write the data definition statements of SQL that modify the structures of a database listed on page 2 of this assessmert in...

[Q.1] Answer the following questions based on the data requirements listed below. [10 points] Data Requirements: Lehman Auto Part factory plans to develop database applications to keep track of the...

This coursework is designed to achieve the following PLOs: PLOs 7 . 2 , 7 . 3 , 7 . 4 , 7 . 5 , 7 . 9 Develop abstract thinking and design ability to analytically demonstrate concepts relating to...

You have been appointed as the tax agent to Dato' Idham, a successful entrepreneur who owns two sole proprietorship businesses and a major shareholder in several private limited companies. Dato'...

24+93/99=24.9393939394 Now we have to find 24/99=93

For each of the following independent cases (AE), compute the missing values in thetable: Total Prime Conversion Direct Direct Manufacturing Manufacturing Case Cost Cost Materials Labor Overheacd...

The Stewart Company has $ 1 , 5 3 0 , 0 0 0 in current assets and $ 6 7 3 , 2 0 0 in current liabilities. Its initial inventory level is $ 3 0 6 , 0 0 0 , and it will raise funds as additional notes...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Explain the difference between Job Analysis, Job Classification, and Job Evaluation.

What does Processing of an OLAP Cube accomplish?

After designing a Multidimensional Database in Visual Studio, what are the next steps that build the Database in the Analysis Services Instance? How is the build out of the Analytical Services...