SELECT DISTINCT tx_signer

FROM near.core.fact_transactions

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '2 years'

AND block_timestamp < CURRENT_DATE - INTERVAL '1 year'

),

active_addresses_this_year AS (

SELECT DISTINCT tx_signer

FROM near.core.fact_transactions

WHERE block_timestamp >= CURRENT_DATE - INTERVAL '1 year'

AND block_timestamp < CURRENT_DATE

SELECT

COUNT(DISTINCT a.tx_signer) AS "Active Addresses This Year (From Last Year)"

FROM active_addresses_last_year a

JOIN active_addresses_this_year b ON a.tx_signer = b.tx_signer;