SELECT PROPOSER as wallet, COUNT(tx_id) as number

from flow.core.fact_transactions

where datediff('day', block_timestamp, CURRENT_DATE ) < 30

and datediff('day', block_timestamp, CURRENT_DATE ) >= 14

GROUP by 1

)

SELECT

case

when number =1 then 'Just one transaction'

when number >1 and number <=5 then 'More than 1 and less than 5 transactions'

when number >5 and number <=10 then 'More than 6 and less than 10 transactions'

when number > 10 and number<=25 then 'More than 11 and less than 26 transactions'

when number > 26 and number<=50 then 'More than 26 and less than 50 transactions'

when number > 50 and number<=100 then 'More than 51 and less than 100 transactions'

when number > 100 and number<=200 then 'More than 101 and less than 200 transactions'

when number > 200 and number<=500 then 'More than 201 and less than 500 transactions'

when number > 500 then 'More than 500 transactions'

end as type , count(wallet) as users

from overall

where type is not null

GROUP by 1