select

delegator_address,

min(completion_time) as osmo_receive_time

from osmosis.core.fact_staking

where action = 'undelegate'

and block_timestamp > '2022-01-01'

group by delegator_address

),

next_transactions as (

select tx_from, tx_id, block_timestamp

from osmosis.core.fact_transactions t

inner join undelegation u on u.delegator_address = t.tx_from

where t.block_timestamp > u.osmo_receive_time

),

first_move as (

select tx_from, tx_id, min(block_timestamp)

from next_transactions

group by tx_from, tx_id

)

select count(distinct fm.tx_id) as count, msg_type

from osmosis.core.fact_msgs m

inner join first_move fm on fm.tx_id = m.tx_id

where msg_type in ('token_swapped', 'pool_joined', 'redelegate', 'ibc_transfer', 'pool_created', 'delegate')

group by msg_type