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