-- ## 12: Active Tickets by Priority (short)  ## --

-- List active tickets and group by ticket priority.

SELECT priority AS __group__,
   id AS ticket, summary, owner, status, t.type AS type, severity, 
   time AS created, changetime AS modified, component
   --## milestone   
   --## description AS _description_   
  FROM ticket t  
  WHERE not status = 'closed'
  ORDER BY priority, owner, severity, time