Query editor
with leader_performance as (selectleader, DATE_TRUNC('day', time) as block_date, COUNT(*) as blocks_produced, SUM(total_transactions) as total_transactions_processed, SUM(successful_transactions) as successful_transactions, SUM(failed_transactions) as failed_transactions, AVG(total_transactions) as avg_transactions_per_block, casewhen SUM(total_transactions) = 0then 0elseSUM(successful_transactions) * 100.0 / SUM(total_transactions)end as success_ratefrom solana_utils.block_leaderswhere time >= CURRENT_DATE - INTERVAL '1460' DAYand not leader is nullgroup byleader, DATE_TRUNC('day', time)), validator_rewards as (selectrecipient as validator, block_date, SUM(lamports) / 1000000000.0 as rewards_sol, COUNT(*) as reward_events, reward_typefrom solana.rewardswhere block_date >= CURRENT_DATE - INTERVAL '30' DAYand reward_type in ('Fee', 'Rent', 'Staking', 'Voting')group byrecipient, block_date, reward_type), validator_reward_summary as (selectvalidator, block_date, SUM(casewhen reward_type = 'Fee'then rewards_solelse0end) as fee_rewards, SUM(casewhen reward_type = 'Rent'then rewards_solelse0end) as rent_rewards, SUM(casewhen reward_type = 'Staking'then rewards_solelse0end) as staking_rewards