from flow.core.fact_events

where EVENT_CONTRACT ilike '%Dimension%'

group by 1

),

per_user as (

select proposer user,

count (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 round (avg(num_transactions)) avg_trasnactions_per_user

from per_user