datavortextesting rewards
    Updated 2024-09-21
    SELECT
    s.delegator_address,
    SUM(s.amount) / POWER(10, 6) AS total_stake_amount,
    SUM(CASE WHEN r.action = 'withdraw_rewards' THEN r.amount END) / POWER(10, 6) AS total_rewards_amount
    FROM
    sei.gov.fact_staking s
    LEFT JOIN
    sei.gov.fact_staking_rewards r
    ON
    s.delegator_address = r.rewards_recipient
    WHERE
    r.tx_succeeded = TRUE
    AND s.action = 'delegate'
    GROUP BY
    s.delegator_address
    ORDER BY
    total_stake_amount DESC
    LIMIT 20;

    QueryRunArchived: QueryRun has been archived