'Terra' AS Chain,

DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS WEEK,

Count(distinct PROPOSAL_ID) AS "Number of submitted proposal",

Count(distinct PROPOSER) AS "Number of PROPOSERS"

from terra.core.fact_governance_submit_proposal where TX_SUCCEEDED=TRUE group by 1,2

union ALL

Select

'Cosmos' AS Chain,

DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS WEEK,

Count(*) AS "Number of submitted proposal",

Count(distinct PROPOSER) AS "Number of PROPOSERS"

from cosmos.core.fact_governance_submit_proposal group by 1,2

UNION ALL

Select

'Osmosis' AS Chain,

DATE_TRUNC('WEEK',BLOCK_TIMESTAMP) AS WEEK,

Count(*) AS "Number of submitted proposal",

Count(distinct PROPOSER) AS "Number of PROPOSERS"

from terra.core.fact_governance_submit_proposal group by 1,2