Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
The team is interested in understanding the business trends of the year of 2019. They want to analyze the monthly revenue trends to gain insights into the company's performance.
Write a query ro calculate the total revenue for each month and the percentage change in revenue from month to month using the transactions table. Round your results into 2 decimal points. Only show the revenue trends of the year of 2019.
Hints:
% change = (Current Month / Prior Month) - 1transactions table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each transaction |
| created_date | The time when the transaction was created |
| value | The monetary value of the transaction |
| purchase_id |
| Identifier for the purchase |
| month | current_month | percentage_change |
|---|---|---|
| 2019-01-01 | 1332636 | 1.30 |
| 2019-02-01 | 952031 | -0.29 |
| 2019-03-01 | 1174373 | 0.23 |
| ... | ... | ... |
| 2019-12-01 | 1116470 | -0.12 |
The team is interested in understanding the business trends of the year of 2019. They want to analyze the monthly revenue trends to gain insights into the company's performance.
Write a query ro calculate the total revenue for each month and the percentage change in revenue from month to month using the transactions table. Round your results into 2 decimal points. Only show the revenue trends of the year of 2019.
Hints:
% change = (Current Month / Prior Month) - 1transactions table:
| Column Name | Description |
|---|---|
| id | Unique identifier for each transaction |
| created_date | The time when the transaction was created |
| value | The monetary value of the transaction |
| purchase_id | Identifier for the purchase |
| month | current_month | percentage_change |
|---|---|---|
| 2019-01-01 | 1332636 | 1.30 |
| 2019-02-01 | 952031 | -0.29 |
| 2019-03-01 | 1174373 | 0.23 |
| ... | ... | ... |
| 2019-12-01 | 1116470 | -0.12 |