with tab1 as (
select
proposer,
count(*) as transactions
from flow.core.fact_transactions
group by 1
Order by 2 DESC
)
select
CASE
when transactions < 2 then 'Less than 2 Transactions'
when transactions between 2 and 5 then 'Between 2 and 5 Transactions'
when transactions between 5 and 7 then 'Between 5 and 7 Transactions'
Else 'Greater than 7 Transactions'
END as group1,
count(*)
from tab1
group by 1