select

case

when PRICE_USD>0 and PRICE_USD<10 then 'Below 10 $'

when PRICE_USD>10 and PRICE_USD<=50 then '10~50 $'

when PRICE_USD>50 and PRICE_USD<=100 then '50~100 $'

when PRICE_USD>100 and PRICE_USD<=500 then '100~500 $'

when PRICE_USD>500 and PRICE_USD<=1000 then '500~1000 $'

when PRICE_USD>1000 then 'Up To 1000 $' end as dis_volume

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

from bsc.nft.ez_nft_sales

where dis_volume is not null

group by 1