iff(block_timestamp >= date('2022-12-23'), 'After BONK', 'Before BONK') as timespan,

count(distinct tx_id) as txns_count,

count(distinct instruction:accounts[1]) as users_count

from solana.core.dim_labels

join solana.core.fact_events

on address = program_id

where block_timestamp between date('2022-12-23') - interval '2 weeks' and date('2022-12-23') + interval '2 weeks'

and label_type in ('defi', 'dex')

and succeeded = 1

group by 1