SELECT COUNT(DISTINCT tx_signer) AS "Users Active in 2023 but Not 2024"
FROM near.core.fact_transactions
WHERE block_timestamp >= '2023-01-01' AND block_timestamp < '2024-01-01'
AND tx_signer NOT IN (
SELECT DISTINCT tx_signer
FROM near.core.fact_transactions
WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2025-01-01'
);