---

SELECT
    ot.id,
    ot.short_name,
    count(*) AS cnt,
    min(o.effective_date) AS min_date,
    max(o.effective_date) AS max_date
FROM back_office.operation o
JOIN back_office.operation_type ot
    ON ot.id = o.operation_type_id
WHERE ot.short_name ILIKE '%выплат%'
GROUP BY
    ot.id,
    ot.short_name
ORDER BY
    ot.short_name;