Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
You're a data analyst at Amazon, and you're being asked to find the platform's top 3 buyers in terms of total spending. You will be using the amazon_purchases table that has the following columns:
| Column Name | Description |
|---|---|
| purchase_id | Unique identifier for each purchase |
| buyer_id | Identifier for the buyer |
| purchase_amount | The amount spent on the purchase |
Write the SQL query to determine the top 3 buyers who have spent the most on Amazon and their total spend.
| buyer_id |
|---|
You're a data analyst at Amazon, and you're being asked to find the platform's top 3 buyers in terms of total spending. You will be using the amazon_purchases table that has the following columns:
| Column Name | Description |
|---|---|
| purchase_id | Unique identifier for each purchase |
| buyer_id | Identifier for the buyer |
| purchase_amount | The amount spent on the purchase |
Write the SQL query to determine the top 3 buyers who have spent the most on Amazon and their total spend.
| buyer_id |
|---|
| 1243 | 145 |
| 131 | 120 |
| 12 | 110 |
| 1243 | 145 |
| 131 | 120 |
| 12 | 110 |