-- ## 9: Active Tickets By Priority ## --

SELECT id AS ticket, status, priority, owner, 
       time as created, summary FROM ticket 
  WHERE status IN ('new', 'assigned', 'reopened', 'accepted')
  ORDER BY priority, time