datavortextesting rewards
Updated 2024-09-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
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