case when price_usd < 10 then 'Less Than $10'

when price_usd >= 10 and price_usd < 100 then '$10 - $100'

when price_usd >= 100 and price_usd < 1000 then '$100 - $1000'

when price_usd >= 1000 and price_usd < 10000 then '$1000 - $10000'

when price_usd >= 10000 and price_usd < 100000 then '$10000 - $100000'

else 'More Than $100000' end as type,

count (distinct buyer_address) as Buyers,

sum(price_usd) as Volume

from ethereum.core.ez_nft_sales

where platform_name = 'blur'

group by 1