I am trying to create a Pivot Table on Oracle Apex with a 'total' row on the bottom of the table. This is currently what I have. How am I able to achieve this on SQL.
SELECT
Committee,
COUNT(CASE WHEN status = 'Resume Review' THEN 1 END) AS "Resume Review",
COUNT(CASE WHEN status = 'Interviewing' THEN 1 END) AS "Interviewing",
COUNT(CASE WHEN status = 'Coding Challenge' THEN 1 END) AS "Coding Challenge",
COUNT(*) AS Total
FROM EMPLOYEES
WHERE status IN ('Resume Review', 'Interviewing', 'Coding Challenge')
GROUP BY Committee;
Any help will be highly appreciated. Thank you!