With whales AS
(select address,balance,wallet_type
from algorand.account
where balance > '100000'
order by balance DESC)
SELECT
swap_program as DEX,
count(swap_program) as Trades
FROM algorand.swaps
LEFT JOIN whales ON swapper = whales.address
WHERE block_timestamp >= '2022-04-01' AND
whales.balance > '100000'
GROUP BY swap_program
ORDER BY swap_program DESC
Limit 20