---

SELECT
    o.operation_type_id,
    ot.short_name,
    max(o.effective_date) AS last_payment_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)
GROUP BY
    o.operation_type_id,
    ot.short_name
ORDER BY last_payment_date DESC;