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'

else 'More Than $10000' end as type,

count (distinct tx_hash) as Sales_count

from ethereum.core.ez_nft_sales

where block_timestamp >= '2022-10-19 04:49:47.000'

group by 1,2

order by 3 desc