Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
Square is interested in analyzing the month-over-month (MoM) change in revenue for its 2 main product verticals: Cash App and Square Core. Round your results by 2 decimal points. It is fine for the percentage change to be null in instances where data from the previous month is unavailable.
You will be using the following tables:
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| order_amount | The amount of the order |
| order_date | The date when the order was placed |
| product_id | The ID of the product |
products table:
| Column Name | Description |
|---|---|
| product_id | Unique identifier for each product |
| product_name | The name of the product |
| month | product_name | percentage_change |
|---|---|---|
| 2023-01-01 | Cash App | null |
| 2023-01-01 | Square Core | null |
| 2023-02-01 | Cash App | -0.49 |
| 2023-02-01 | Square Core | -0.60 |
| 2023-03-01 | Cash App | 0.54 |
Square is interested in analyzing the month-over-month (MoM) change in revenue for its 2 main product verticals: Cash App and Square Core. Round your results by 2 decimal points. It is fine for the percentage change to be null in instances where data from the previous month is unavailable.
You will be using the following tables:
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| order_amount | The amount of the order |
| order_date | The date when the order was placed |
| product_id | The ID of the product |
products table:
| Column Name | Description |
|---|---|
| product_id | Unique identifier for each product |
| product_name | The name of the product |
| month | product_name | percentage_change |
|---|---|---|
| 2023-01-01 | Cash App | null |
| 2023-01-01 | Square Core | null |
| 2023-02-01 | Cash App | -0.49 |
| 2023-02-01 | Square Core | -0.60 |
| 2023-03-01 | Cash App | 0.54 |