[Solved]Question 6 10 Points 8 Product Categories Products Categories Tables Vice President Sales Q37298390
Question 6 (10 points) There are 8 product categories in the products and categories tables. The Vice President of Sales, Dr. Fuller wants a report that lists the names of the product categories and the total number of sales orders and the total sales amount for each product category Write a query using the products, order details, and categories tables (Hint must multiple unitprice by quantity and subtract discount to get total sales, use 3 tables, products, categories and order details) Product Category Seafood Number of Orders 330 Total Sales 141623.09 Question 7 (10 points) The Sales Manager wants a report with the companyname from the customer table, OrderlID from the order details table, CategoryName from the categories table, productName fom the products table, and price, computed from the order details table as the (unitprice* quantity discount). (Use 4 tales, order details, categories, products, and orders tables). The output should look like the image below: Customer Vins et alcools Chevalier Vins et alcools Chevalier Vins et alcools Chevalier Toms Spezialitäten Toms Spezialitäten Sales Number 10248 10248 10248 10249 10249 Product Category Dairy Products Grains/Cereals Dairy Products Product Name Queso Cabrales Singaporean Hokkien Fried Mee Mozzarella di Giovanni Tofu Manjimup Dried Apples Price 98 174 167.4 1696 Produce Products 9 ProductiD ProductName SupplierlD CategorylD QuantityPerUnit UnitPrice UnitsinStock UnitsOnOrder ReorderLevel Discontinued Categories 9 CategorylD CategoryName Description Picture Order Details OrderllD ProductiD UnitPrice Quantity Discount Show transcribed image text Question 6 (10 points) There are 8 product categories in the products and categories tables. The Vice President of Sales, Dr. Fuller wants a report that lists the names of the product categories and the total number of sales orders and the total sales amount for each product category Write a query using the products, order details, and categories tables (Hint must multiple unitprice by quantity and subtract discount to get total sales, use 3 tables, products, categories and order details) Product Category Seafood Number of Orders 330 Total Sales 141623.09 Question 7 (10 points) The Sales Manager wants a report with the companyname from the customer table, OrderlID from the order details table, CategoryName from the categories table, productName fom the products table, and price, computed from the order details table as the (unitprice* quantity discount). (Use 4 tales, order details, categories, products, and orders tables). The output should look like the image below: Customer Vins et alcools Chevalier Vins et alcools Chevalier Vins et alcools Chevalier Toms Spezialitäten Toms Spezialitäten Sales Number 10248 10248 10248 10249 10249 Product Category Dairy Products Grains/Cereals Dairy Products Product Name Queso Cabrales Singaporean Hokkien Fried Mee Mozzarella di Giovanni Tofu Manjimup Dried Apples Price 98 174 167.4 1696 Produce
Products 9 ProductiD ProductName SupplierlD CategorylD QuantityPerUnit UnitPrice UnitsinStock UnitsOnOrder ReorderLevel Discontinued Categories 9 CategorylD CategoryName Description Picture Order Details OrderllD ProductiD UnitPrice Quantity Discount
Expert Answer
Answer to Question 6 (10 points) There are 8 product categories in the products and categories tables. The Vice President of Sales… . . .
OR
