SELECT
COUNT(CASE WHEN DATE_TRUNC('YEAR', block_timestamp) = DATE_TRUNC('YEAR', CURRENT_DATE) THEN SIGNER_ID END) AS this_year_staked,
COUNT(CASE WHEN DATE_TRUNC('YEAR', block_timestamp) = DATE_TRUNC('YEAR', DATEADD(YEAR, -1, CURRENT_DATE)) THEN SIGNER_ID END) AS last_year_staked
FROM
near.gov.fact_staking_actions
WHERE
ACTION = 'staking'