-- ## 9: Active Tickets by Priority ## --

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