SELECT "SPOOLER_ID" AS "JOB_SCHEDULER", "JOB_CHAIN", 
       "ORDER_ID", COUNT(*) AS "ORDER_COUNT", 
       SUM("END_TIME"-"START_TIME") AS "ELAPSED"
  FROM SCHEDULER_ORDER_HISTORY s
 WHERE DATE("START_TIME") >= CURRENT_DATE - INTERVAL '10 DAY'
   AND COALESCE(DATE("END_TIME"), CURRENT_DATE - INTERVAL '1 DAY') <= CURRENT_DATE
 GROUP BY 1, 2, 3;