program_id,

count(tx_id) as trxs

from solana.core.fact_events

where block_timestamp>'2022-01-01'

and succeeded='true'

group by 1

order by 2 desc

limit 10