Количество зачисленных по разным решениям

SELECT faculty.name AS "Факультет",
CASE WHEN substring(speciality.name for 3) = 'Бак' THEN substring(speciality.name from 5) || ' (бакалавриат)'
WHEN substring(speciality.name for 3) = 'Маг' THEN substring(speciality.name from 5) || ' (магистратура)'
WHEN substring(speciality.name for 4) = 'Спец' AND faculty.name IN ('Факультет СПО ИТИ', 'Бендерский политехнический филиал СПО и НПО')
        THEN substring(speciality.name from 6)
WHEN substring(speciality.name for 4) = 'Спец' THEN substring(speciality.name from 6) || ' (специалитет)'
ELSE speciality.name END AS "Специальность",
forma.name As "Форма обучения",
language.name AS "Язык обучения",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id = 5) AS "ВнеКонкурса",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id = 4) AS "ПоКонкурсу",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id = 12) AS "ПоКвоте",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id = 12) AS "ПоКвоте",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id = 11) AS "ПослеОплаты",
(SELECT COUNT(*) FROM treiting, entrant WHERE entrant.delete = '0' AND treiting.entrant_id = entrant.id AND entrant.allset_id = allset.id AND treiting.solution_id IS NULL) AS "После оплаты"
FROM allset, speciality, faculty, forma, language
WHERE allset.speciality_id = speciality.id AND speciality.faculty_id = faculty.id AND allset.forma_id = forma.id AND language.id = allset.language_id AND
faculty.names NOT IN ('ТКОЛ', 'БПФ', 'ФДО', 'РФ', 'БФ')
ORDER BY 1