case when date >= '2022-11-15' then 'After replace '

when date < '2022-11-15 ' then 'Before replace' else null end as timespan,

count (distinct tx_id) as TX_Count,

count (distinct signers[0]) as Users_Count

from solana.core.fact_transactions t1 join solana.core.dim_labels t2 on t1.instructions[0]:programId = t2.address

where address_name not in ('token program','associated token account','systeminstruction','memo program','config_instruction','token 2022 program','pyth oracle')

and timespan is not null

and succeeded = 'TRUE'

group by 1,2

order by 1 desc

LIMIT 1000