-- Calculate how many NFTs each buyer has sold

SELECT

seller_address,

COUNT(tokenid) AS nfts_sold

FROM

base.nft.ez_nft_sales

WHERE

platform_name = 'opensea'

GROUP BY

seller_address

SELECT

COUNT(DISTINCT seller_address) AS sellers,

CASE

WHEN nfts_sold < 5 THEN 'Less than 5 NFTs'

WHEN nfts_sold BETWEEN 5 AND 10 THEN '5 to 10 NFTs'

WHEN nfts_sold BETWEEN 11 AND 50 THEN '11 to 50 NFTs'

WHEN nfts_sold BETWEEN 51 AND 100 THEN '51 to 100 NFTs'

WHEN nfts_sold BETWEEN 101 AND 500 THEN '101 to 500 NFTs'

WHEN nfts_sold > 500 THEN 'Above 500 NFTs'

END AS amount_range

FROM

seller_distribution

GROUP BY

amount_range

ORDER BY

amount_range;