count(distinct signers[0]) as stakers,

CASE WHEN date >= '2022-10-11' THEN 'Post hack' ELSE 'Pre hack' END as group1

from solana.core.ez_staking_lp_actions

where event_type in ('delegate') and SUCCEEDED = TRUE

and date >= '2022-10-01'

group by 1,3