select
miner, count(*) as n_blocks_mined,
(n_blocks_mined/2826306) as percentage_mined,
-- n_blocks_mined/percentage_mined as adj_n_blocks_mined,
row_number() over (order by n_blocks_mined desc) as rank
from ethereum.core.fact_blocks
where tx_count >= 0 and tx_count <= 3
group by miner
order by n_blocks_mined desc