CASE

WHEN date < '2023-01-14' THEN 'Before Station Announcement'

ELSE 'After Station Announcement' END as time_label,

COUNT(DISTINCT tx_id) as txs

FROM terra.core.ez_staking

WHERE date BETWEEN '2023-01-01' and '2023-01-21'

GROUP BY 1