CASE WHEN (price_usd) <= 100 THEN 'a.below 100'

WHEN (price_usd) > 100 and (price_usd) <=500 THEN 'b.100-500'

WHEN (price_usd) > 500 and (price_usd) <=2000 THEN 'c.500-2000'

WHEN (price_usd) > 2000 and (price_usd) <=10000 THEN 'd.2000-10000'

WHEN (price_usd) > 10000 THEN 'e.above 10000'

END as buckets,

count(distinct tx_hash) as sale_no,

count(distinct BUYER_ADDRESS) as buyer_no

from ethereum.core.ez_nft_sales

where PLATFORM_NAME='rarible'

group by 1 having buckets is not null