with tab1 as (

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'

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 > current_Date - 180

AND succeeded

HAVING NUM_ACCOUNTS = 15

)

where not dao is NULL

--AND proposal like 'BnfFejPpykmTtM5TyNEySgRCctRizmrZe9Bbe8V1UTon'

--and dao like 'Meta DAO'

), tab2 as (

pass_amm as amm,