Platform_name,

NFT_ADDRESS,

count(*) as sales,

count(distinct buyer_address) as nft_buyers,

count(distinct seller_address) as nft_sellers,

SUM(TOTAL_PRICE) AS sales_volume,

AVG(TOTAL_PRICE) AS average_sale_price,

sum(CREATOR_FEE) as creator_fees,

sum(PLATFORM_FEE) as platform_fees,

sum(TOTAL_FEES) as fees,

FROM aptos.nft.ez_nft_sales

where nft_address ilike '%Aptos Ecosystem Fundamentals%'

group by 1,2

order by 3 desc