b.miner,

round(count(distinct b.HASH)/10)+1 as blocks_count

from

ethereum.core.fact_blocks b join ethereum.core.fact_transactions t on b.hash=t.BLOCK_HASH

where

b.BLOCK_TIMESTAMP>CURRENT_DATE-60

group by

miner

select

blocks_count*10 as cnt,

count(*) as frequency

from

miners

group by

blocks_count

order by

blocks_count