adambalaDetails Table
    Updated 2023-02-06

    with a as
    (select
    count(distinct ID) as vote ,
    count(distinct VOTER) as VOTERs ,
    sum(VOTING_POWER) as voting_powers ,
    PROPOSAL_ID as PROPOSAL
    from ethereum.core.ez_snapshot --where PROPOSAL_ID ='0xcfc63eee1d5dde8e890deec9aca9d1e3965c99f864a4bc6da1dbf273ac5ae3c4'
    where SPACE_ID = 'doodles.eth'
    group by 4
    )


    select
    distinct PROPOSAL_ID as PROPOSAL_ID ,
    case when vote between 1 and 10 then '🔥'
    when vote between 10 and 50 then '🔥🔥'
    when vote between 50 and 100 then '🔥🔥🔥'
    when vote between 100 and 1000 then '🔥🔥🔥🔥'
    else '🔥🔥🔥🔥🔥' end as popularity,
    vote,
    VOTERs,
    voting_powers,
    voting_powers/10000 || '%'as voting_powers_ratio ,
    PROPOSAL_TITLE ,
    CHOICES ,
    QUORUM ,
    VOTING_PERIOD ,
    PROPOSAL_START_TIME ,
    PROPOSAL_END_TIME ,
    PROPOSAL_TEXT ,
    case when voting_powers between 1 and 10 then '♨️'
    when voting_powers between 10 and 50 then '♨️♨️'
    when voting_powers between 50 and 100 then '♨️♨️♨️'
    when voting_powers between 100 and 1000 then '♨️♨️♨️♨️'
    Run a query to Download Data