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. 

City State Country Region Market Product ID Category Sub Category Product Name Sales Quantity Discount Profit  
 X 23 fields selected Order_ID Order Date Ship_Date Ship_Mode Customer_ID STRING DATE DATE STRING STRING 

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

1 Expert Approved Answer
Step: 1 Unlock

Based on the dataset youve provided which includes fields like OrderDate CustomerID Country ProductI... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!