Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prompt: The Sales department wants to know how many customer orders were placed during the months of February and March in the year 2013. They

image text in transcribed

image text in transcribed

Prompt: The Sales department wants to know how many customer orders were placed during the months of February and March in the year 2013. They want the list to show the employee ID who processed the order and then the number of orders processed by that employee, and name that column as "Order Count. type your answer... Employeeld, type your answer... (OrderID) AS "Order Count" type your answer... CustOrder WHERE Order Date BETWEEN "2013-02-01" AND "2013-03-31" ORDER BY EmployeelD; Prompt: The Sales department wants a list that will identify the product with the largest gross sales over all sales. They want the output to include the product name and its total gross sales amount (sales before discount) named as Gross Sale." Sort the query output in descending order by the gross sale, then by the product name. SELECT Product. FROM SUM(Sale Product. type your answer... *Sale Product. type your answer... AS type your answer... " FROM Sale Product JOIN Product type your answer... Sale Product.ProdID = Product. type your answer... GROUP BY SaleProduct type your answer... ORDER BY "Gross Sale" DESC product.ProdName

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

Principles Of Financial Accounting Chapters 1 To 18

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel

12th Edition

9781118978740

More Books

Students also viewed these Accounting questions