below is my report query and I need you to help add a line that adds up the total time spent on the request:

SELECT wo.WORKORDERID AS "Request ID", wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", cd.CATEGORYNAME AS "Category", ti.FIRST_NAME AS "Assigned Technician", ct.TIMESPENT AS "Time Spent" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID 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 SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID WHERE  ((cd.CATEGORYNAME = 'Vista') AND (((wo.CREATEDTIME >= datetolong('1488279600000') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= datetolong('1490957999000') AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST 

regards,

Jonathan