platform_name,

count (distinct tx_hash) as Sales,

count (distinct buyer_address) as Buyers,

count (distinct seller_address) as Sellers,

count(distinct nft_address) as NFT_count,

count(distinct tokenid) as NFTs,

sum(platform_fee_usd) as Total_platform_fee_usd,

min(platform_fee_usd) as min_platform_fee_usd,

avg(platform_fee_usd) as avg_platform_fee_usd,

max(platform_fee_usd) as max_platform_fee_usd,

(sum(platform_fee_usd) / sum(price_usd)) * 100 as percent_platform_fee,

sum(price_usd) as Sales_volume,

avg(price_usd) as avg_price

from ethereum.core.ez_nft_sales

where platform_fee_usd > 0

group by 1)

select

platform_name,

percent_platform_fee,

(Total_platform_fee_usd / Sales ) as Sales_ratio,

(Total_platform_fee_usd / Buyers ) as Buyers_ratio,

(Total_platform_fee_usd / Sellers ) as Sellers_rato,

(Total_platform_fee_usd / NFT_count ) as Project_ratio,

(Total_platform_fee_usd / NFTs ) NFT_ratio

from main