-- ## 11: Active Tickets by Priority (Full Description) ## --

-- 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,
   description AS _description_   
  FROM ticket t  
  WHERE not status = 'closed'
  ORDER BY priority, owner, severity, time