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

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.

Crumbl Cookies
more

From Bakery to You: Crumbl Cookies’ Nationwide Delivery Service

Crumbl Cookies, a rapidly growing bakery chain, has established itself as a premier destination for freshly baked, gourmet cookies delivered straight to customers’ doorsteps. If you’re wondering where to get dessert in Houston, Crumbl should be at the top of your list. With a focus on innovation and a commitment to quality, Crumbl has become […]

Read More
The Best Cookies in Chicago: Indulge in Sweet Delights
more

The Best Cookies in Chicago: Indulge in Sweet Delights

Discover Chicago’s Sweetest Treats Chicago, known for its dynamic food scene, is home to probably the most heavenly cookies you’ll at any point taste. From exemplary chocolate chips to remarkable manifestations, Breezy City offers plenty of choices for cookie sweethearts. Go along with us on a great excursion through Chicago’s best pastry kitchens and find […]

Read More
Grown Diamonds
more

Unlocking the Mysteries of Inclusions in Lab-Grown Diamonds

Lab-grown diamonds have become increasingly popular due to their ethical and sustainable nature, but just like their natural counterparts, they too can have inclusions. Understanding these inclusions is crucial for consumers to make informed decisions when purchasing lab-grown diamonds. In this article, we’ll delve into the world of inclusions in lab-grown diamonds, exploring their types, […]

Read More