'Terra' AS Chain,

dayname(BLOCK_TIMESTAMP::Date) AS Day,

Count(*) AS "Number of submitted proposal"

from terra.core.fact_governance_submit_proposal group by 1,2

union ALL

Select

'Cosmos' AS Chain,

dayname(BLOCK_TIMESTAMP::Date) AS Day,

Count(*) AS "Number of submitted proposal"

from cosmos.core.fact_governance_submit_proposal group by 1,2

UNION ALL

Select

'Osmosis' AS Chain,

dayname(BLOCK_TIMESTAMP::Date) AS Day,

Count(*) AS "Number of submitted proposal"

from osmosis.core.fact_governance_submit_proposal group by 1,2