SELECT "SPOOLER_ID" AS "JOB_SCHEDULER", "JOB_NAME", "ERROR", 
       "START_TIME", "END_TIME", "END_TIME"-"START_TIME" AS "ELAPSED" 
  FROM SCHEDULER_HISTORY
 WHERE "START_TIME" >= DATE_SUB(CURRENT_DATE, INTERVAL 10 DAY)
   AND IFNULL(DATE("END_TIME"), DATE_SUB(CURRENT_DATE, INTERVAL 1 DAY)) <= CURRENT_DATE
   AND "JOB_NAME" <> '(Spooler)'
 GROUP BY 1, 2, 3, 4, 5, 6;