trunc(block_timestamp,'month') as date,

case when tx_count >=100 then 'High transaction count'

else 'Low transaction count' end as n_transactions,

count(distinct miner) as miners

from ethereum.core.fact_blocks

where tx_count<>0

group by 1,2

order by 1 asc