Question: generate some SQL queries to find some analysis of a Ecom store using a dataset. 1. How many customers purchased products each
generate some SQL queries to find some analysis of a Ecom store using a dataset.
1. How many customers purchased products each month on average?
2. What is the best-selling product in each Country? (Hints: use Quantity as the indicator for best- selling measure)
City State Country Region Market Product ID Category Sub Category Product Name Sales Quantity Discount Profit Shipping Cost Order_Priority Delivery Days STRING STRING STRING STRING STRING STRING STRING STRING STRING INTEGER INTEGER FLOAT INTEGER INTEGER STRING INTEGER NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE NULLABLE
Step by Step Solution
There are 3 Steps involved in it
Based on the dataset youve provided which includes fields like OrderDate CustomerID Country ProductI... View full answer
Get step-by-step solutions from verified subject matter experts
