select case when price_usd < 1000 then 'Less Than $1000'
when price_usd >= 1000 and price_usd < 5000 then '$1000 - $5000'
when price_usd >= 5000 and price_usd < 10000 then '$5000 - $10000'
when price_usd >= 10000 and price_usd < 25000 then '$10000 - $25000'
when price_usd >= 25000 and price_usd < 50000 then '$25000 - $50000'
when price_usd >= 50000 and price_usd < 100000 then '$50000 -$100000'
else 'More Than $100000' end as type,
count (distinct tx_hash)
from ethereum.core.ez_nft_sales
where nft_address = '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d'
and price_usd > 0
group by 1
order by 2 desc