-- ## 9: test trac report sample ## --

-- from TracReports

SELECT *  FROM ticket   WHERE status IN ('new', 'assigned', 'reopened') 
  ORDER BY severity, time