Platform_name as "Platform name"

,sum(creator_fee_usd) as "Creator fee($)"

,avg(creator_fee_usd) as "Avg Creator fee($)"

,median(creator_fee_usd) as "Median Creator fee($)"

,(sum(creator_fee_usd) / sum(price_usd))*100 as "%Creator fee percent"

,sum(price_usd) as "volume"

,avg(price_usd) as "Avg price"

,count(distinct buyer_address) as "number of buyers "

from ethereum.core.ez_nft_sales

group by 1

having sum(CREATOR_FEE_USD) > 0

order by 2 desc