How to add custom column to SQL output?

Question

Oracle

There is a request:

select count(d.id) as КОЛИЧЕСТВО from deal d
where d.status in ('3', '4')

It turns out a table:
QUANTITY
32
12
And it is necessary that it be, if status 3, then an error, and if 4, then success:
QUANTITY STATUS
32 ERROR
12 SUCCESSFUL

Answer 1

SELECT COUNT(d.id) AS КОЛИЧЕСТВО, (CASE WHEN d.status = '3' THEN 'ОШИБКА' ELSE 'УСПЕШНО' END) AS СТАТУС
FROM deal d
WHERE d.status IN ('3', '4')
GROUP BY d.status

Answer 2

SELECT COUNT(d.id) AS КОЛИЧЕСТВО, CASE WHEN d.status = '3' THEN 'ОШИБКА' ELSE 'УСПЕШНО' END AS СТАТУС
FROM deal d
WHERE d.status IN ('3', '4')
GROUP BY CASE WHEN d.status = '3' THEN 'ОШИБКА' ELSE 'УСПЕШНО' END