Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
As a Data Analyst at Amazon, the Go-to-Market team want to identify the top 5% of spenders on the platform. Pull the list of these top spenders including their name, and total_spend.
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user. |
| name | The name of the user |
orders table:
| Column Name | Description |
|---|---|
| order_id |
| Unique identifier for each order. |
| order_amount | The total amount of the order |
| buyer_id | The user_id who purchased the order |
| name | total_spend |
|---|---|
| Keyla Thom | 416.80 |
| Nathan Bisto | 316.35 |
| Mike Lenard | 266.50 |
| Lily Hu | 245.60 |
As a Data Analyst at Amazon, the Go-to-Market team want to identify the top 5% of spenders on the platform. Pull the list of these top spenders including their name, and total_spend.
users table:
| Column Name | Description |
|---|---|
| user_id | Unique identifier for each user. |
| name | The name of the user |
orders table:
| Column Name | Description |
|---|---|
| order_id | Unique identifier for each order. |
| order_amount | The total amount of the order |
| buyer_id | The user_id who purchased the order |
| name | total_spend |
|---|---|
| Keyla Thom | 416.80 |
| Nathan Bisto | 316.35 |
| Mike Lenard | 266.50 |
| Lily Hu | 245.60 |