r.rewards_recipient,

SUM(r.amount) / POWER(10, 6) AS total_rewards_amount

FROM

sei.gov.fact_staking_rewards r

WHERE

r.tx_succeeded = TRUE

AND r.action = 'withdraw_rewards'

AND r.block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '7 days'

GROUP BY

r.rewards_recipient

ORDER BY

total_rewards_amount DESC

LIMIT 10;