Kruys-Collinsawkward-lime
    Updated 2024-09-16
    SELECT
    COUNT(DISTINCT delegator_address) AS unique_delegators,
    COUNT(*) AS total_staking_transactions,
    SUM(CASE WHEN action = 'delegate' AND tx_succeeded = TRUE THEN 1 ELSE 0 END) AS total_delegate_transactions
    FROM
    axelar.gov.fact_staking
    WHERE
    action IN ('delegate', 'undelegate', 'redelegate')
    AND tx_succeeded = TRUE;

    QueryRunArchived: QueryRun has been archived