count(distinct proposal_id) as cnt,

'last year' as label

FROM cosmos.core.fact_governance_submit_proposal

WHERE block_timestamp :: date >= CURRENT_DATE - 365

AND block_timestamp :: date <= '2023-02-16'

UNION

SELECT

count(distinct proposal_id) AS cnt,

'last 7 days' as label

FROM cosmos.core.fact_governance_submit_proposal

WHERE block_timestamp :: date >= '2023-02-16'