How to withdraw the amount from GROUP BY?

Question

MySQL

In the request:

SELECT d.name,
       sc.name,
       qg.count + qg.shortened + qg.total_tape as "План приёма",
       qg.count as "на базе 9 класса",
       qg.shortened as "на базе 10 класса",
       qg.total_tape as "на базе ТИПО",
       count(*) as "всего принято заявлений"
********
GROUP BY d.name, sc.name, qg.count + qg.shortened + qg.total_tape, qg.count, qg.shortened, qg.total_tape

Displays the amount, but like this:
college 1 / 123
college 1 / 12
college 1 / 345
and I need to have college 1 / and the whole amount is this

Answer 1

Aggregation is needed, SUM