ESS - ESS Jobs Submitted Last 30 Days

SELECT 
     TRUNC(submission) AS Last_30_Days, 
     COUNT(requestid) AS Count_of_Jobs 
 FROM 
     fusion.ESS_REQUEST_HISTORY 
 WHERE 
     submission > SYSDATE - 30 
 GROUP BY TRUNC(submission) 
 ORDER BY 1 DESC;