SELECT

PROJECT_NAME,

BUYER_ADDRESS,

SUM(TOTAL_PRICE_USD) AS total_purchase_volume

FROM

aptos.nft.ez_nft_sales

WHERE

project_name = 'Aptos Monkeys'

GROUP BY

PROJECT_NAME,

BUYER_ADDRESS

),

distribution AS (

SELECT

PROJECT_NAME,

CASE

WHEN total_purchase_volume < 50 THEN '0-50 USD'

WHEN total_purchase_volume >= 50 AND total_purchase_volume < 100 THEN '50-100 USD'

WHEN total_purchase_volume >= 100 AND total_purchase_volume < 500 THEN '100-500 USD'

WHEN total_purchase_volume >= 500 AND total_purchase_volume < 1000 THEN '500-1000 USD'

ELSE '1000+ USD'

END AS purchase_volume_range,

COUNT(DISTINCT BUYER_ADDRESS) AS buyer_count

FROM

tab1

GROUP BY

PROJECT_NAME,

purchase_volume_range

SELECT

-- PROJECT_NAME,

purchase_volume_range,

buyer_count

FROM

distribution