PLATFORM_NAME,

TX_HASH,

sum(TOTAL_FEES_USD) as total_fee,

sum(PRICE_USD) as volume,

avg(PRICE_USD) as avg_volume,

median(PRICE_USD) as median_volume

from base.nft.ez_nft_sales

group by PLATFORM_NAME order by 1 DESC),

SELECT PROJECT_NAME,

TX_HASH,

NFT_FROM_ADDRESS

FROM base.nft.ez_nft_transfers),

SELECT *

FROM platforms_nft p

LEFT JOIN nft_salers s on p.TX_HASH = s.TX_HASH