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