-- forked from analysttex / indirect-emerald @ https://flipsidecrypto.xyz/analysttex/q/hHVPs2s-MUSh/indirect-emerald
select
Platform,
count (*) as total_swaps
from
bsc.defi.ez_dex_swaps
where
inserted_timestamp > current_date - interval '90 days'
group by
platform
order by
total_swaps desc
limit 8