where block_timestamp > '2022-02-01'),

all_txs as

(SELECT block_id as bid, count(*) as total_txs from (SELECT * from solana.events

where block_timestamp > '2022-02-01' )

GROUP by 1 )

SELECT avg(num_votes) as avg_num_votes, median(num_votes) as median_num_votes, avg(total_txs) as avg_non_vote, median(total_txs) as median_non_vote, avg(percent_vote_non_vote) as avg_percent_vote_non_vote

,median(percent_vote_non_vote) as median_percent_vote_non_vote

from

(SELECT *, num_votes/total_txs as percent_vote_non_vote from all_txs

inner join vote_txs

on block_id = bid)