---

CREATE TEMP TABLE my_dates AS
SELECT id, client_id, topic,
       CASE
           WHEN created_at LIKE '__.__.____%'
           THEN substr(created_at, 7, 4) || '-' ||
                substr(created_at, 4, 2) || '-' ||
                substr(created_at, 1, 2) || ' ' ||
                substr(created_at, 12, 5) || ':00'
           ELSE created_at
       END AS created
FROM (SELECT DISTINCT * FROM tickets);

SELECT COUNT(*)
FROM my_dates
WHERE created >= '2025-04-01';

SELECT COUNT(*)
FROM clean
WHERE period = 'после';