platform_name as marketplaces,

count (distinct tx_hash) as tx_sales,

count (distinct buyer_address) as buyers,

count (distinct seller_address) as sellers,

sum (price_usd) as usd_volume,

sum (creator_fee_usd) as royalty_usd,

sum(creator_fee_usd) / sum(price_usd) * 100 as creator_fee

from ethereum.core.ez_nft_sales

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

group by 1