With general as (select
block_number,
block_timestamp,
tx_count,
difficulty,
miner
from ethereum.core.fact_blocks
where network = 'mainnet' AND blockchain = 'ethereum' and tx_count <= 50
)
select
miner,
count(distinct block_number) as blocks
from general
group by 1
order by 2 DESC