date_trunc('month', block_timestamp) as month,

CASE WHEN tx_count < 20 THEN 'a Below 20 Transactions'

WHEN tx_count < 50 THEN 'b Between 20 and 50 Transactions'

WHEN tx_count < 100 THEN 'c Between 50 and 100 Transactions'

WHEN tx_count < 200 THEN 'd Between 100 and 200 Transactions'

WHEN tx_count < 300 THEN 'e Between 200 and 300 Transactions'

WHEN tx_count < 400 THEN 'f Between 300 and 400 Transactions'

ELSE 'g Over 400 Transactions' END as block_group,

COUNT(DISTINCT block_number)

FROM ethereum.core.fact_blocks

GROUP BY 1,2