-- This query finds the most active buyers by the number of purchases.
WITH BuyerActivity AS (
SELECT BUYER_ADDRESS, COUNT(*) AS NumPurchases
FROM optimism.nft.ez_nft_sales
GROUP BY BUYER_ADDRESS
)
SELECT BUYER_ADDRESS, NumPurchases
FROM BuyerActivity
ORDER BY NumPurchases DESC
LIMIT 10;