I need to report query to generate total time spent(total work log) per ticket by engineer.The table must contain   project,ticket id,ticket subject,time spent engineer and total time spent. Can you help me to create report query for same 

 Version : 9.0 Build 9004

Database : postgres