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 "START_TIME" >= CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME) - 10
   AND COALESCE("END_TIME", GETDATE() - 1) <= GETDATE()
 GROUP BY "SPOOLER_ID", "JOB_CHAIN", "ORDER_ID";