Question
SQL Create the following summary query: By Product Name list the following: Category Name Product Name total product sales amount - (Calculated field using the
SQL
Create the following summary query: By Product Name list the following: Category Name Product Name total product sales amount - (Calculated field using the Orders Detail table: UnitPrice * Quantity) total number of products ordered - (the sum of the quantity *10 field within the Order Details table) This should be for all products with a category of Condiments or Beverages and whose order discount is 0. Filter out (remove from result set) products whose total number of products ordered is 300 or greater. ** your result set should return 12 rows hint: this is a group by and you will need 4 tables
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