ESS - Jobs Completed Last Hour With Success Message

SELECT DECODE(state, 
            1,'Wait', 
            2,'Ready', 
            3,'Running', 
            5,'Blocked', 
            7,'Cancelling', 
            9,'Cancelled', 
            10,'Error', 
            12,'Succeeded', 
            13,'Paused', 
            state) AS Status, 
        COUNT(requestid) AS count 
 FROM FUSION.ESS_REQUEST_HISTORY 
 WHERE state IN (12) 
   AND submission > (SELECT SYSDATE - INTERVAL '1' HOUR FROM dual) 
 GROUP BY state 
 ORDER BY COUNT(requestid) DESC;