Question: 2. How do quantities sold per product differ across states? Sales Table: Sales_Order_ID (PK), Unique identifier for each sales order, Product_Code (FK) Unique identifier (from


2. How do quantities sold per product differ across states? Sales Table: Sales_Order_ID (PK), Unique identifier for each sales order, Product_Code (FK) Unique identifier (from Finished_Good_Products table) for each sales product, Sales_Order_Quantity_Sold Sales order line quantity, Product_Sale_Price Sales order line price per unit. Product Table: Product_Code (PK) Unique identifier for each product, Product_Description Product description (plain English) to indicate the name or other identifying characteristics of the product, Product_Sale_Price-Price per unit of the associated product. Customer Table: Customer_ID (PK) Unique identifier for each customer, Customer_St the physical state where the customer is located, Customer_City-The physical city where the customer is located, Customer_Zip-The zip code of the city where the customer is physically located
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
