with tb1 as (select count(trunc(block_timestamp,'month')) as month,
'Aurora' as type,
from_address as address
from aurora.core.fact_transactions
where block_timestamp::date >= '2022-07-30'
group by 2,3)
,
tb2 as (select count(trunc(block_timestamp,'month')) as month,
'Near' as type,
tx_signer as address
from near.core.fact_transactions
where block_timestamp::date >= '2022-07-30'
group by 2,3)
,
tb3 as ( select count(DISTINCT address) as near
from tb2
where month = 12)
,
tb4 as ( select count(DISTINCT address) as aurora
from tb1
where month = 12)
select aurora , near
from tb3, tb4