SELECT
epoch_earned,
COUNT(DISTINCT stake_pubkey) as num_reward_recipients,
SUM(reward_amount_sol) as total_rewards_sol
FROM SOLANA.gov.fact_rewards_staking
WHERE epoch_earned >= 730
AND stake_pubkey IN (
SELECT DISTINCT stake_pubkey
FROM SOLANA.gov.fact_stake_accounts
WHERE vote_pubkey = 'gangtRyGPTvYWb8K3xS2feJQaCks4iJ7rytFUPtVqSY'
AND epoch >= 730
)
GROUP BY epoch_earned
ORDER BY epoch_earned DESC;