Ravindra BagaleCourses & study guides Track your progress

12. GROUP BY: One Row Per Group

12.6 Practice: Tickets by Agent and Status

By Last updated:

Why. Ticket boards are natural GROUP BY stories.

What. Group interview_mini tickets by agent and by status.

How. One key, then two keys, with clear aliases.

Steps

  1. Count by agent.
  2. Count by status.
  3. Count by agent + status.

Examples

Example 1 · dataset: interview_mini

SELECT agent, COUNT(*) AS tickets
FROM tickets
GROUP BY agent
ORDER BY tickets DESC;

Output

agenttickets
Elena3
Sofia1
Priya1
Omar1
James1
Chen1

Meaning. Workload by agent.

Example 2 · dataset: interview_mini

SELECT agent, status, COUNT(*) AS n
FROM tickets
GROUP BY agent, status
ORDER BY agent, status;

Output

agentstatusn
ChenClosed1
ElenaClosed1
ElenaOpen2
JamesOpen1
OmarOpen1
PriyaOpen1
SofiaClosed1

Meaning. Agent × status grid in SQL form.

Ravindra Bagale's Tip

Chala mitrano — rebuild the agent×status query from memory tomorrow.