support_queue (ticket_id, priority, created_at, subject) holds open support tickets. priority runs from 1 (can wait) to 4 (urgent).
The on-call engineer wants the queue in this order:
- •the most urgent tickets first (highest
priority); - •within the same priority, the newest ticket first;
- •if two tickets have the same priority and were opened at the same moment, the smaller
ticket_id first.
Columns: ticket_id, priority, created_at.