Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
For each buyer username, get the maximum spend within their region. Regions are categorized into 3 buckets: USA, Canada, and Other. Only account for users that purchased at least 1 order.
You will have access to 2 tables: users and orders table:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user. |
| username | The username chosen by the user. |
| country | The country where the user is located. |
orders table:
| Column Name |
|---|
| order_id | Unique identifier for each order. |
| buyer_id | The user_id of the user who placed the order. |
| seller_id | The user_id of the user who is selling the item. |
| order_amount | The total amount of the order in currency units. |
| username | total_spent | max_spent_by_country |
|---|---|---|
| ArtisticAmy | 420 | 420 |
| WoolWeaver | 210 | 480 |
| BeadsBuddy | 65 | 480 |
| SewSavvy | 130 | 480 |
For each buyer username, get the maximum spend within their region. Regions are categorized into 3 buckets: USA, Canada, and Other. Only account for users that purchased at least 1 order.
You will have access to 2 tables: users and orders table:
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user. |
| username | The username chosen by the user. |
| country | The country where the user is located. |
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| buyer_id | The user_id of the user who placed the order. |
| seller_id | The user_id of the user who is selling the item. |
| order_amount | The total amount of the order in currency units. |
| username | total_spent | max_spent_by_country |
|---|---|---|
| ArtisticAmy | 420 | 420 |
| WoolWeaver | 210 | 480 |
| BeadsBuddy | 65 | 480 |
| SewSavvy | 130 | 480 |