from terra.core.fact_transactions

group by 2)

,

months as ( select trunc(date,'month') as month, count(DISTINCT(contracts)) as total_contract

from contracts

group by 1)

,

active as ( select trunc(block_timestamp,'month') as months, count(DISTINCT(tx:body:messages[0]:contract)) as contracts

from terra.core.fact_transactions

group by 1)

select 'New Contracts' as type,concat(MONTH_OF_YEAR,'.',month_name) as monthly , month, total_contract

from months a left outer join ethereum.core.dim_dates b on a.month = b.date_day

select 'Active Contracts' as type, concat(MONTH_OF_YEAR,'.',month_name) as monthly , months, contracts as total_contract

from active a left outer join ethereum.core.dim_dates b on a.months = b.date_day