with tab1 as (
SELECT
proposal_id as p_id,
PROPOSAL_TYPE as p_type,
block_timestamp as p_time
FROM terra.core.fact_governance_submit_proposal
)
SELECT COUNT(DISTINCT VOTER) as voters,
COUNT(DISTINCT TX_ID) as votes
FROM terra.core.fact_governance_votes
LEFT outer JOIN tab1
ON p_id = proposal_id
WHERE p_time is not NULL