,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