count(distinct (tx_id)) as txn_count,

count(distinct (instruction:accounts[1])) as users_count,

(txn_count / users_count) as avg_txn_per_user

from solana.core.fact_events

where block_timestamp::date >= '2022-11-11'

and succeeded = 1

and program_id = 'srmqPvymJeFKQ4zGQed1GFppgkRHL9kaELCbyksJtPX'

order by txn_count desc