rezarwzThe wallets that contributed the most, in which dao were they most active.
    Updated 2022-08-17
    with base as(
    SELECT *,
    CASE
    when REALMS_ID = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'
    when REALMS_ID = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'
    when REALMS_ID = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance'
    when REALMS_ID = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend'
    when REALMS_ID = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'
    when REALMS_ID = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'Metaplex Genesis'
    when REALMS_ID = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation'
    when REALMS_ID = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet'
    when REALMS_ID = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum'
    when REALMS_ID = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'
    when REALMS_ID = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'
    else 'We dont want it'
    End as DAO_NAME
    FROM solana.core.fact_proposal_votes
    WHERE DAO_NAME!='We dont want it' and SUCCEEDED='TRUE' and GOVERNANCE_PLATFORM='realms'
    ),
    top_100 as (
    SELECT
    COUNT(DISTINCT tx_id) as transactions_by_wallet,
    voter as top_100_voter
    from base
    GROUP BY voter
    ORDER BY transactions_by_wallet DESC
    LIMIT 100
    ),
    main_select as(
    SELECT *
    from(top_100 INNER JOIN base on base.voter=top_100.top_100_voter)
    )
    SELECT
    COUNT(DISTINCT tx_id) as number_of_transactions,
    dao_name,
    main_select.voter
    Run a query to Download Data