Hola
Prueba esta consulta y actualiza cuál es el resultado
SELECT COUNT(*) AS TOTAL_C1_COUNT, A.STATUS ,
CASE A.STATUS = 'RESOLVED' THEN
SECONDS_BETWEEN (TO_TIMESTAMP(CONCAT(CONCAT(A.CALL_CREATION_DT,' '),
A.CALL_CREATION_TIME)),
TO_TIMESTAMP(CONCAT(CONCAT(B.JOB_DONE_DATE,' '),
B.JOB_DONE_TIME)))/(24*3600)
ELSE 0 END AS RESOLVED_TIME,
CASE A.STATUS != 'RESOLVED' THEN
(SECONDS_BETWEEN (TO_TIMESTAMP(CONCAT(CONCAT ( A.CALL_CREATION_DT,' '),
A.CALL_CREATION_TIME ) ),
CURRENT_TIMESTAMP)/(24*3600))
ELSE 0 END AS WORKING_TIME
FROM CALL_REGISTER A LEFT JOIN CALL_RESOLVED B ON A.CALL_NO = B.CALL_NO
WHERE A.DEALER_CODE IN ('XXX') AND A.CATEG IN ('C1');