platform,

SUM(amount_in_usd) Total_amount

base.defi.ez_dex_swaps

GROUP BY

1

ORDER BY

2 DESC --LIMIT 100