case

when PRICE_USD>0 and PRICE_USD<=10 then '1 ~ 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 then 'Up To 10000 $' end as dis_volume

,count(distinct BUYER_ADDRESS)as "Buyer Count"

,count(distinct SELLER_ADDRESS)as "Seller count"

--,sum(PRICE_USD) as "USD Sale Price"

,count(distinct TOKENID)as "Token Count"

,count(distinct TX_HASH) as "Sale Count"

--,avg(PRICE_USD) as "Total Avg USD Sale Volume"

from ethereum.core.ez_nft_sales

where NFT_ADDRESS='0x629a673a8242c2ac4b7b8c5d8735fbeac21a6205'

and PLATFORM_NAME='opensea'

and PRICE_USD>0

group by 1