select

case

when PRICE>0 and PRICE<0.1 then 'Below 0.1 ETH'

when PRICE>0.1 and PRICE<=0.5 then '0.1~0.5 ETH'

when PRICE>0.5 then 'Up to 0.5 ETH' end as price_dis

,count(distinct TOKENID) as nft_sold

,count(distinct TX_HASH) as sale_count

from base.nft.ez_nft_sales

where price_dis is not null

group by 1