crypto_gosttotal staked this year vs last year
    Updated 2024-11-18
    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'





    QueryRunArchived: QueryRun has been archived