extract(week from t1.date) as week,

t1.date,

t.proposal_id::text as proposal_id,

t.proposal_type,

t1.no_unique_voter,

t2.total_deposit,

t2.total_depositor

(select

block_timestamp::date as date,

proposal_id,

proposal_type

from osmosis.core.fact_governance_submit_proposal ) t

inner join

block_timestamp::date as date,

proposal_id,

count(distinct voter) as no_unique_voter

from osmosis.core.fact_governance_votes

group by 1, 2) t1

on t.date = t1.date

and t.proposal_id = t1.proposal_id

inner join

block_timestamp::date as date,

proposal_id,

sum(amount) as total_deposit,

count(distinct depositor) as total_depositor

from osmosis.core.fact_governance_proposal_deposits

where tx_succeeded

group by 1,2) t2

on t1.date = t2.date

and t1.proposal_id = t2.proposal_id)