S.PLATFORM_NAME, -- Selects the PLATFORM_NAME column from the ez_nft_sales table

SUM(S.PLATFORM_FEE_USD) AS TotalPlatformFeesUSD -- Calculates the total platform fees in USD and aliases it as TotalPlatformFeesUSD

aptos.nft.ez_nft_sales S -- Specifies the ez_nft_sales table as S

aptos.nft.ez_nft_mints M -- Specifies the ez_nft_mints table as M

S.NFT_ADDRESS = M.NFT_ADDRESS -- Joins rows where the NFT_ADDRESS column in ez_nft_sales matches the NFT_ADDRESS column in ez_nft_mints

AND S.TOKENID = M.TOKENID -- and where the TOKENID column in ez_nft_sales matches the TOKENID column in ez_nft_mints

GROUP BY

S.PLATFORM_NAME; -- Groups the results by the PLATFORM_NAME column in ez_nft_sales