Pending Report with Aging

Pending Report with Aging

I have this query:


SELECT wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",cd.CATEGORYNAME "Category",wo.TITLE "Subject",ti.FIRST_NAME "Technician", std.STATUSNAME "Request Status", FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (( std.STATUSNAME = 'Onhold') OR ( std.STATUSNAME = 'Open')) AND wot.THD_WOID=wot.WORKORDERID


but I want to add another column showing the age of the ticket in days

                  New to ADSelfService Plus?