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