mariyawhales
    Updated 2022-04-19
    with whales as (select sum(balance) as sm, address from algorand.account
    group by address
    having sm > 100000)
    , whales_swaps as (select distinct swapper from algorand.swaps where swapper in(select address from whales))

    select count(*) from whales