-- ## 9: Closed Tickets ## --

SELECT id AS ticket, status, severity, priority, owner, 
       time as created, summary FROM ticket 
  WHERE status IN ('closed', 'invalid', 'worksforme')
  ORDER BY priority, time