sinahosseinzadehUntitled Query
    Updated 2022-08-31
    with table1 as (
    select top 10 voter as whale_address, sum(voting_power) as whale_weight
    from ethereum.core.ez_snapshot
    where voter not in ('0xD9A8bf5A0f51fd33E81cec86b0e9761D29ED8A2B', '0x8DEa94aC7A9625e16195961059f88945aad80472', '0xe29074dF944657963a135a3dBA0A81c24D5df140',
    '0x37234aEd028E0814437FB19F45F0E6075748B706', '0x61e681391dD71e183764A20AEF5Cfd3b2f1435C7', '0x03f946Edda019aa760B724F7947015b36533CBBF',
    '0xBa03EcA6b692532648c4da21840fB9Af578147A2', '0x02aE1C8BFD8F2E7d0452Dd2fcDbBD711fF92d321', '0xc87b3Aa99A33E929e1558857597d53Ed413aeEc7')
    group by whale_address
    order by whale_weight desc
    ),

    table2 as (select voter as wallet_address, sum(voting_power) as wallet_weight
    from ethereum.core.ez_snapshot
    where voter not in (select whale_address from table1)
    group by wallet_address)

    select 'Whales' as users, sum(whale_weight) as total from table1
    union
    select 'Users' as users, sum(wallet_weight) as total from table2
    group by users
    Run a query to Download Data