ESS - Count of ESS Jobs Submitted Last 24 Hours

SELECT 
     DECODE(state, 
            1,'SCHEDULED', 
            11,'WARNING', 
            2,'READY', 
            12,'SUCCEEDED', 
            3,'RUNNING', 
            13,'PAUSED', 
            4,'COMPLETED', 
            14,'PENDING_VALIDATION', 
            5,'BLOCKED', 
            15,'VALIDATION_FAILED', 
            6,'HOLD', 
            16,'SCHEDULE_ENDED', 
            7,'CANCELLING', 
            17,'FINISHED', 
            8,'EXPIRED', 
            18,'ERROR_AUTO_RETRY', 
            9,'CANCELLED', 
            19,'ERROR_MANUAL_RECOVERY', 
            10,'ERROR', 
            state) AS state, 
     COUNT(requestid) AS count 
 FROM 
     fusion.ESS_REQUEST_HISTORY 
 WHERE 
     submission > SYSDATE - 1 
 GROUP BY state 
 ORDER BY 2 DESC;