select

date_trunc('month', block_timestamp) as Date_Month,

'Near' as Chain,

count(distinct tx_hash) as Proposals

from near.core.fact_actions_events_function_call a left outer join near.core.dim_address_labels

on RECEIVER_ID = address

where method_name like 'add_proposal'

and block_timestamp > current_date - 730 -- Two years

and creator like 'Near Foundation'

and label_type like 'dao'

group by 1,2

, Cosmos as (

select

date_trunc('month', block_timestamp) as Date_Month,

'Cosmos' as Chain,

count(distinct proposal_id) as Proposals

from cosmos.core.fact_governance_votes

where block_timestamp > current_date - 730

group by 1,2

)

, Terra as (

select

date_trunc('month', block_timestamp) as Date_Month,

'Terra' as Chain,

count(distinct proposal_id) as Proposals

from terra.core.fact_governance_votes

where block_timestamp > current_date - 730

group by 1,2

)

select *