SELECT COUNT(DEFINITION) AS COUNT, DEFINITION
FROM FUSION_ORA_ESS.request_HISTORY
WHERE STATE = 3
GROUP BY DEFINITION
HAVING COUNT(DEFINITION) > 20
ORDER BY 1 DESC;
SELECT COUNT(DEFINITION) AS COUNT, DEFINITION
FROM FUSION_ORA_ESS.request_HISTORY
WHERE STATE = 3
GROUP BY DEFINITION
HAVING COUNT(DEFINITION) > 20
ORDER BY 1 DESC;