SQL at Wok Series MIS Report

Input: daily_cases

SELECT queue_name,
       COUNT(*) AS total_cases,
       SUM(CASE WHEN status = 'Closed' THEN 1 ELSE 0 END) AS closed_cases,
       SUM(CASE WHEN status = 'Open' THEN 1 ELSE 0 END) AS open_cases
FROM daily_cases
GROUP BY queue_name
ORDER BY queue_name;