I'm using the following to show tickets that have been closed, with newly closed tickets at the top:

```
SELECT 
   p.value AS __color__,
   id AS ticket, 
   summary, 
   component,
   version,
   milestone,
   t.type AS type, 
   owner, 
   status,
   time AS created,
   changetime AS _changetime,
   description AS _description,
   reporter AS _reporter
  FROM ticket t
  LEFT JOIN enum p ON p.name = t.priority AND p.type = 'priority'
  WHERE status = 'closed'
  ORDER BY changetime DESC, time DESC, CAST(p.value AS integer), milestone, t.type, time

```

Here are the columns that currently show:

```
Ticket
Summary
Component
Version
Milestone
Type
Owner
Status
Created

```

I'd like to **add** the date closed to the report view (and perhaps a third column showing the date difference). How would I go about this?