SELECT

date_trunc('week', block_timestamp) as week,

instruction['accounts'][0] as proposal,

case when instruction['accounts'][1] like 'ofvb3CPvEyRfD5az8PAqW6ATpPqVBeiB5zBnpPR5cgm' then 'Future DAO'

when instruction['accounts'][1] like '9TKh2yav4WpSNkFV2cLybrWZETBWZBkQ6WB6qV9Nt9dJ' then 'Deans List DAO'

when instruction['accounts'][1] like '5vVCYQHPd8o3pGejYWzKZtnUSdLjXzDZcjZQxiFumXXx' then 'Drift'

when instruction['accounts'][1] like 'CNMZgxYsQpygk8CLN9Su1igwXX2kHtcawaNAGuBPv3G9' then 'Meta DAO'

when instruction['accounts'][1] like '7XoddQu6HtEeHZowzCEwKiFJg4zR3BXUqMygvwPwSB1D' then 'ORE'

when instruction['accounts'][1] like 'B3PDBD7NCsJyxSdSDFEK38oNKZMBrgkg46TuqqkgAwPp' then 'Jito'

when instruction['accounts'][1] like '5n61x4BeVvvRMcYBMaorhu1MaZDViYw6HghE8gwLCvPR' then 'Sanctum'

end as dao,

instruction['accounts'][7] as fail_amm,

instruction['accounts'][4] as pass_amm,

instruction['accounts'][2] as usdc_vault,

instruction['accounts'][3] as token_vault

FROM (

SELECT

*,

len(INSTRUCTION['accounts']) as lrn,

ARRAY_SIZE(instruction['accounts']) as num_accounts,

INSTRUCTION['accounts']

FROM solana.core.fact_events

WHERE program_id LIKE 'autoQP9RmUNkzzKRXsMkWicDVZ3h29vvyMDcAYjCxxg'

AND block_timestamp > '2024-05-01'

AND succeeded

HAVING NUM_ACCOUNTS = 15

)

where not dao is NULL

), tab2 as (

pass_amm as amm,

dao,

from tab1