Oracle Message QSM-01059 - HAVING clause in the query block is malformed

ERRORHAVING clause in the query block is malformed
CAUSEAn illegal HAVING clause has been specified in the query.
ACTIONCorrect the query syntax and run the query again.