from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

),

per_user as (

select

proposer ,

count (DISTINCT tx_id) num_transactions

from flow.core.fact_transactions

where tx_id in (select tx_id from events )

and TX_SUCCEEDED = true

group by 1

)

select case when num_transactions = 1 then 'one Transaction'

when num_transactions BETWEEN 1 and 2 then '1 - 2 transactions'

when num_transactions BETWEEN 2 and 5 then '2 - 5 transactions'

when num_transactions BETWEEN 5 and 10 then '5 - 10 transactions'

when num_transactions BETWEEN 10 and 15 then '10 - 15 transactions'

when num_transactions BETWEEN 15 and 20 then '15 - 20 transactions'

else 'greater than 20 transactions'

end range ,

count (proposer) num_users

from per_user

group by 1