DISTINCT platform AS DEXs,

COUNT(DISTINCT TX_HASH) AS Total_Trades

FROM aptos.defi.ez_dex_swaps

GROUP BY 1

ORDER BY 2 DESC