superflyUntitled Query
    Updated 2022-09-23
    select proposal_id as proposal,
    case when proposal_id = '0xd810c4cf2f09737a6f833f1ec51eaa5504cbc0afeeb883a21a7e1c91c8a597e4' then 'Ratification of the ENS DAO Constitution'
    when proposal_id = '0xac288d9a71911ccf4a75c8e12558bb8363dcba1cb7639d68c0ea670fbda24ab8' then 'Cancel the direct destruction of 50% of the transaction volume'
    when proposal_id = '0x03dfd8c644fc219c6c3c3482b5f7b3ad16a72dfd24d31ded3a880e6b1d290562' then 'TBCC DAO and TBCC TOKEN'
    when proposal_id = '0x44aba87414d2d7ce88218b676d9938338d7866a245f48a7829e805a99bcda6a2' then 'Arbitrum Odyssey Poll 1'
    when proposal_id = '0x5f0d63dd8b8c19f244944c9165875852377aeb2543e53b603292bb14c5094d44' then 'Launchpad TBCC' else proposal_id end as proposal_name,
    space_id,
    count (distinct id) as Votes,
    count (distinct voter) as Voters
    from ethereum.core.ez_snapshot
    group by 1,2,3
    order by 4 DESC
    limit 5
    Run a query to Download Data