superflyUntitled Query
    with dao as (
    select column1 AS address, column2 AS dao_name
    FROM( VALUES
    ('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', 'mango')
    ,('2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', 'Metaplex Foundation')
    ,('3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg', 'Serum')
    ,('B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6', 'MonkeDAO')
    ,('6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', 'The Imperium of Rain')
    ,('7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn', 'Solend')
    ,('FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', 'Psy Finance')
    ,( 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip', 'Grape')
    ,('7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP', 'Synthetify')
    ,('78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh', 'Jet')
    ,('Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817', 'Metaplex Genesis')
    )
    )
    , tb as (
    select *
    from dao
    )
    , chains as (
    select
    block_timestamp::date as date,
    'Solana' as blockxhain,
    case when VOTE_CHOICE is null then 'NULL'
    else VOTE_CHOICE end as vote_type,
    voter,
    tx_id as vote,
    proposal as PROPOSAL_ID,
    VOTE_WEIGHT as VOTING_POWER
    from tb a join solana.core.fact_proposal_votes b on a.address = b.realms_id
    where SUCCEEDED = 'TRUE'

    Run a query to Download Data