SELECT miner,

COUNT(DISTINCT block_number) as blocks, sum(TX_COUNT) as total_TX,(total_TX/blocks) as transaction_per_block

FROM ethereum.core.fact_blocks

WHERE block_timestamp >= '2022-01-01'

AND tx_count > 0

group by 1)

select DISTINCT miner as miner,transaction_per_block

FROM ern

where transaction_per_block >=186

order by 2 desc