Query editor
selectCOUNT(*) as total_vote_transactions, COUNT(distinct signer) as total_voting_validators, SUM(fee) / 1000000000.0 as total_vote_fees_sol, AVG(compute_units_consumed) as avg_compute_units_per_vote, COUNT(casewhen success = falsethen 1end) as total_failed_votes, ROUND((COUNT(casewhen success = truethen 1end) * 100.0) / NULLIF(COUNT(*), 0), 2) as vote_success_rate_percent, (selectsignerfrom solana.vote_transactionswhere block_date is not nullgroup bysignerorder byCOUNT(*) desclimit 1) as most_active_voting_validatorfrom solana.vote_transactionswhere block_date is not null;