with stakers as (select distinct INSTRUCTION:parsed:info:stakeAuthority as users from solana.events where event_type='delegate')
select count(*),EVENT_TYPE from solana.events inner join stakers where solana.events.INSTRUCTION:parsed:info:stakeAuthority=stakers.users
group by EVENT_TYPE