---

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, 37, 112, 173)
  AND cast(o.effective_date as date)
      BETWEEN DATE '2026-08-17' AND DATE '2026-09-07'
GROUP BY
    o.operation_type_id,
    ot.short_name,
    cast(o.effective_date as date)
ORDER BY operation_date;