bachirealmsdao3
    Updated 2022-08-31
    with monkedao as (
    select count(distinct(voter)) as no_of_voters,
    count(distinct(tx_id)) as no_of_votes_casted,
    count(distinct(proposal)) as no_of_proposals
    from solana.core.fact_proposal_votes
    where succeeded = 'TRUE' and realms_id ilike 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6'
    and governance_platform = 'realms'
    --group by day
    ),
    synthetify as (
    select --date(block_timestamp) as day,
    count(distinct(voter)) as no_of_voters,
    count(distinct(tx_id)) as no_of_votes_casted,
    count(distinct(proposal)) as no_of_proposals
    from solana.core.fact_proposal_votes
    where succeeded = 'TRUE' and realms_id ilike '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP'
    and governance_platform = 'realms'
    --group by day
    ),
    imperium as (
    select --date(block_timestamp) as day,
    count(distinct(voter)) as no_of_voters,
    count(distinct(tx_id)) as no_of_votes_casted,
    count(distinct(proposal)) as no_of_proposals
    from solana.core.fact_proposal_votes
    where succeeded = 'TRUE' and realms_id ilike '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn'
    and governance_platform = 'realms'
    -- group by day
    ),

    serum as (
    select --date(block_timestamp) as day,
    count(distinct(voter)) as no_of_voters,
    count(distinct(tx_id)) as no_of_votes_casted,
    count(distinct(proposal)) as no_of_proposals
    from solana.core.fact_proposal_votes
    Run a query to Download Data