---

SELECT
    o.operation_type_id,
    ot.short_name,
    cast(o.effective_date as date) AS operation_date,
    count(*) AS cnt
FROM back_office.operation o
JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
WHERE o.operation_type_id IN (35, 112, 37, 173)
  AND o.effective_date >= DATE '2025-01-01'
  AND o.effective_date <  DATE '2025-02-01'
GROUP BY
    o.operation_type_id,
    ot.short_name,
    cast(o.effective_date as date)
ORDER BY operation_date, o.operation_type_id;