SELECT

--project_name,

--date_trunc('day', block_timestamp) as day,

BUYER_ADDRESS,

COUNT(DISTINCT tx_hash) as sales,

count(DISTINCT BUYER_ADDRESS) as buyers,

sum(PRICE_USD) as Volume_usd,

avg(PRICE_USD) AS avg_price

FROM optimism.core.ez_nft_sales

LEFT outer JOIN optimism.core.dim_labels

on NFT_ADDRESS = address

GROUP BY 1

--ORDER BY 2 DESC

--LIMIT 30

CASE WHEN Volume_usd < 5 THEN 'a Under 5 USD'

WHEN Volume_usd < 10 THEN 'b Between 5 - 10 USD'

WHEN Volume_usd < 50 THEN 'c Between 10 - 50 USD'

WHEN Volume_usd < 100 THEN 'd Between 50 - 100 USD'

WHEN Volume_usd < 500 THEN 'e Between 100 - 500 USD'

WHEN Volume_usd < 1000 THEN 'f Between 500 - 1,000 USD'

ELSE 'g Over 1,000 USD' end as group1,

count(*)

FROM tab1

GROUP BY 1