KeyrockSEI - Percentage Stakers
    Updated 2024-05-30
    WITH
    CTE_1 AS (
    SELECT COUNT(DISTINCT TX_CALLER_ADDRESS) AS Stakers
    FROM sei.gov.fact_staking
    ),
    CTE_2 AS (
    SELECT COUNT(DISTINCT tx_from) AS tot_wallet
    FROM sei.core.fact_transactions
    WHERE tx_succeeded = 'TRUE'
    )

    SELECT
    CTE_1.Stakers,
    CTE_2.tot_wallet,
    CTE_1.Stakers * 100.0 / NULLIF(CTE_2.tot_wallet, 0) AS percentage_stakers
    FROM
    CTE_1, CTE_2;

    QueryRunArchived: QueryRun has been archived