WITH TotalVolume AS (
SELECT
platform AS PlatformName,
SUM(amount_in_usd) AS TotalVolumeUSD
FROM
polygon.defi.ez_dex_swaps
WHERE
block_timestamp >= DATEADD(MONTH, -3, CURRENT_DATE)
GROUP BY
platform
)
SELECT
PlatformName AS Platform,
TotalVolumeUSD AS TotalVolumeUSD,
(TotalVolumeUSD * 100.0 / SUM(TotalVolumeUSD) OVER ()) AS VolumePercentageShare
FROM
TotalVolume
ORDER BY
TotalVolumeUSD DESC;