farid-c9j0VMUntitled Query
    Updated 2022-08-18
    with T as (SELECT *,
    case when realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' or realms_id = 'EJw396bhCYaQUmcUQ6SHAgCWBXjxxLG1VBDxDi7mhU6q' then 'MANGO DAO'
    when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' or realms_id = '83FAo555RKkvuNmPhwJoqo9udvp4DKTj7jBYiMWZLFey' then 'PSY FINANCE'
    when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'GRAPE'
    when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' or realms_id ='6gcJCdWmWe2JuMX7Tyhs3gQD5pgxRZcF4kz8LTKMMTH9' then 'SOLEND'
    when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MONKE DAO'
    when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' or realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'METAPLEX'
    when realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' or realms_id = 'ATnhhZJ74xg4mzxDyNQ5YAE1BZ98PhrhAsMS4xNXquvX' then 'JET'
    when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' or realms_id = '5pNokKBsf5EaAVrFbKPuhoYiCu7awsiGsmYqnKwpjvxr' then 'SERUM'
    when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'THE IMPERIUM OF RAIN'
    when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'SYNTHETIFY'
    else null
    END AS dao_name
    from solana.core.fact_proposal_votes
    where dao_name is not null
    )
    select dao_name,proposal,avg(count distinct tx_id)
    from T
    group by 1,2
    Run a query to Download Data