from near.core.fact_actions_events_function_call a join near.core.dim_address_labels b on a.receiver_id = b.address

where block_timestamp::date >= '{{Start_Date}}' and block_timestamp::date <= '{{End_Date}}'

group by 1)

,

aurora as (select from_address as user, count(DISTINCT(trunc(block_timestamp,'month'))) as month

from aurora.core.fact_transactions

where block_timestamp::date >= '{{Start_Date}}' and block_timestamp::date <= '{{End_Date}}'

group by 1)

,

max as (select count(DISTINCT(trunc(block_timestamp,'month'))) as month

from aurora.core.fact_transactions

where block_timestamp::date >= '{{Start_Date}}' and block_timestamp::date <= '{{End_Date}}')

,

near_active as (select count(DISTINCT(user)) as near_user

from near

where month in (select month from max))

,

aurora_active as (select count(DISTINCT(user)) as aurora_user

from aurora

where month in (select month from max))

select near_user, aurora_user

from aurora_active , near_active