ManageEngine Servicedesk request time spent by technicion

gistfile1.txt

SELECT 
	CASE WHEN sdo.NAME IS NULL THEN sdo2.Name ELSE sdo.NAME END "Site",
	COALESCE(wtk.WORKORDERID , wo.workorderid) "Ticket Number", 
	CASE WHEN to_timestamp(MAX(wo.createdtime)/1000)::DATE IS NULL THEN to_timestamp(MAX(wo2.createdtime)/1000)::DATE ELSE to_timestamp(MAX(wo.createdtime)/1000)::DATE END"Request Created Date",	
	to_timestamp(MAX(ct.createdtime)/1000)::TIMESTAMP "Time Spent Created Time", 	
	rctd.FIRST_NAME "Time Spent Technician",
	CAST(SUM(ct.TIMESPENT) AS FLOAT)/1000/3600 "Time Spent",
	CASE WHEN MAX(tk.TASKID) IS NOT NULL THEN MAX(wo2.TITLE) ELSE MAX(wo.TITLE) END "Title",
	ct.DESCRIPTION FROM ChargesTable ct
LEFT JOIN WorkOrderToCharge wotoc ON ct.CHARGEID=wotoc.CHARGEID
LEFT JOIN WorkOrder wo ON wotoc.WORKORDERID=wo.WORKORDERID
LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID
LEFT JOIN  TaskDetails tk ON tkc.TASKID=tk.TASKID
LEFT JOIN SiteDefinition siteDef2 ON tk.SITEID=siteDef2.SITEID 
LEFT JOIN SDOrganization sdo2 ON siteDef2.SITEID=sdo2.ORG_ID
LEFT JOIN WorkorderToTaskDetails wtk ON tk.TASKID=wtk.TASKID
LEFT JOIN Workorder wo2 ON wtk.WORKORDERID=wo2.WORKORDERID
LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID 
LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID
LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID 
LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID
WHERE (wtk.WORKORDERID IS NOT NULL OR wo.workorderid IS NOT NULL)  
AND ct.CREATEDTIME >= <from_lastmonth> 
AND ct.CREATEDTIME <= <to_lastmonth>  
GROUP BY sdo.NAME, sdo2.NAME, COALESCE(wtk.WORKORDERID , wo.workorderid), rctd.FIRST_NAME, ct.DESCRIPTION
ORDER BY 6, 1, 3, 4