BLOCK_HEADER_JSON:miner AS miner,

COUNT(*) AS blocks_mined

FROM

polygon.core.fact_blocks

WHERE

BLOCK_TIMESTAMP >= '2023-09-01'

AND BLOCK_TIMESTAMP < '2023-10-01'

GROUP BY

BLOCK_HEADER_JSON:miner

ORDER BY

blocks_mined DESC;