Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started