select

b.block_id,

v.block_timestamp,

tx_count,

num_votes,

num_votes*100/tx_count as vote_tx_percent

from solana.votes_block_agg v join solana.blocks b on v.block_id=b.block_id

select

date(block_timestamp) as date,

count(block_id) as blocks,

sum(tx_count) as tx_count,

sum(tx_count)-sum(num_votes) as non_vote_txs,

sum(num_votes) as votes_tx,

avg(vote_tx_percent) as avg_vote_percent,

votes_tx*100/sum(tx_count) as avg_daily_vote_percent

from vote_tx

group by 1