case when block_timestamp >= '2022-09-01' and block_timestamp <'2022-10-11 23:00:00.000' then 'Before Mango Hack'

when block_timestamp >= '2022-10-11 23:00:00.000' then 'After Mango Hack' else null end as timespan,

count (distinct tx_id) as TX_Count,

count (distinct signers[0]) as Users_Count

from solana.core.fact_transactions

where instructions[0]:programId in ('mv3ekLzLbnVPNxjSKvqBpU3ZeZXPQdEC3bp5MDEBG68','5fNfvyp5czQVX77yoACa3JJVEhdRaWjPuazuWgjhTqEH','JD3bq9hGdy38PuWQ4h2YJpELmHVGPPfFSuFkpzAd9zfu')

and block_timestamp >= '2022-09-01'

and timespan is not null

and succeeded = 'TRUE'

group by 1,2

order by 1