MySQL error: HAVING is not valid at this position, expecting EOF, ‘;’

Question

Im having that problem in this specific line:

SELECT city, SUM(credit_limit) AS total_limit 
FROM table 
GROUP BY city 
ORDER BY total_limit 
HAVING SUM(credit_limit) < 110000;

Probably is a stupid error, but im not seeing a syntax problem here.

Answer

SELECT city, SUM(credit_limit) AS total_limit FROM table GROUP BY city ORDER BY total_limit WHERE SUM(credit_limit) < 110000;

Accepted Answer

SELECT city, SUM(credit_limit) AS total_limitFROM tableGROUP BY cityORDER BY total_limitWHERE SUM(credit_limit) < 110000;