with miners as
(
select
BLOCK_AUTHOR as miner,
round(count(distinct BLOCK_ID)/10)+1 as blocks_count
from
near.core.fact_blocks
where
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