miner, count(*) as n_blocks_mined,

(n_blocks_mined/5150062)*100 as percentage_mined,

row_number() over (order by n_blocks_mined desc) as rank

from ethereum.core.fact_blocks

where tx_count >= 150

group by miner

order by n_blocks_mined desc

limit 10