with wallets as (
select
inner_instruction:instructions[1]:parsed:info:authority as wallets_preordered
from solana.core.fact_events where program_id='781wH11JGQgEoBkBzuc8uoQLtp8KxeHk1yZiS1JhFYKy' and succeeded='TRUE'
and block_timestamp>= '2022-06-23'
)
select
wallets_preordered,
count(distinct tx_id) as count_of_txs
from wallets ,solana.core.fact_transfers
where tx_from=wallets_preordered
GROUP BY 1
ORDER BY count_of_txs DESC