select
miner, count(*) as n_tx, avg(tx_count) as avg_tx_count,
median(tx_count) as median_tx_count
-- (n_blocks_mined/575050)*100 as percentage_mined,
-- row_number() over (order by n_blocks_mined desc) as rank
from ethereum.core.fact_blocks
group by miner
order by n_tx desc
limit 20