Monthly Customer Report
Start Timer
0:00:00
Write a query to show the number of users, number of transactions placed, and total order amount per month in the year 2020. Assume that we are only interested in the monthly reports for a single year (January-December).
Example:
Input:
transactions table
| Column | Type |
|---|---|
id |
INTEGER |
user_id |
INTEGER |
created_at |
DATETIME |
product_id |
INTEGER |
quantity |
INTEGER |
products table
| Column | Type |
|---|---|
id |
INTEGER |
name |
VARCHAR |
price |
FLOAT |
users table
| Column | Type |
|---|---|
id |
INTEGER |
name |
VARCHAR |
sex |
VARCHAR |
Output:
| Column | Type |
|---|---|
month |
INTEGER |
num_customers |
INTEGER |
num_orders |
INTEGER |
order_amt |
INTEGER |
Recommended questions for you
Personalized based on your user activity, skill level, and preferences.
.
.
.
.
.
.
.
.
.
Comments