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';