count (block_number) as block_count,

case when tx_count>0 and tx_count< 5 then 'less than 5 trxs'

when tx_count>=5 and tx_count< 10 then 'between 5 to 10 trxs'

when tx_count>=10 and tx_count< 20 then 'between 10 to 20 trxs'

when tx_count>=20 and tx_count< 50 then 'between 20 to 50 trxs'

when tx_count>=50 and tx_count< 100 then 'between 50 to 100 trxs'

when tx_count>=100 and tx_count< 150 then 'between 100 to 150 trxs'

when tx_count>=150 and tx_count< 200 then 'between 150 to 200 trxs'

when tx_count>=200 and tx_count< 500 then 'between 200 to 500 trxs'

when tx_count>=500 and tx_count< 1000 then 'between 500 to 1000 trxs'

when tx_count>=500 and tx_count< 1000 then 'between 500 to 1000 trxs'

when tx_count>=500 and tx_count< 1000 then 'between 500 to 1000 trxs'

else 'more than 1K trxs'

end as category

from ethereum.core.fact_blocks

where tx_count>1000

group by 1, 3

order by 2 desc