Top 3 Spenders buyer_ids

Medium

Using the results from the previous query:

SELECT 
    buyer_id,
    SUM(purchase_amount) AS total_spent
FROM amazon_purchases
GROUP BY 1
ORDER BY 2 DESC
LIMIT 3

You're being asked to modify this query to only select the buyer_id of the top 3 spenders.

Medium

Using the results from the previous query:

SELECT 
    buyer_id,
    SUM(purchase_amount) AS total_spent
FROM amazon_purchases
GROUP BY 1
ORDER BY 2 DESC
LIMIT 3

You're being asked to modify this query to only select the buyer_id of the top 3 spenders.

Modules