count (distinct tx_hash) as Sales,

sum (price_usd) as Volume,

count (distinct buyer_address) as Buyers,

count (distinct seller_address) as Sellers

from ethereum.core.ez_nft_sales

where platform_name in ('opensea','looksrare','x2y2')

and creator_fee_usd =0

group by 1