---

SELECT
    at.mnemonics,
    COUNT(a.id) AS account_count
FROM back_office.account_type at
LEFT JOIN back_office.account a
    ON a.account_type_id = at.id
WHERE at.mnemonics IN ('Р ОПС', 'Р ОПС ИД')
GROUP BY at.mnemonics
ORDER BY at.mnemonics;