count (distinct tx_id) as trxs,

count (distinct signers[0]) as users,

case when date < '2022-12-24' then 'Before $BONK Launch'

else 'After $BONK Launch' end as period

from solana.core.fact_transactions

where block_timestamp::date >= '2022-12-01'

group by 1, 4