这段语句中为什么 老是报错 ‘HAVING avgAge>17; ’？

Question

SELECT addr,GROUP_CONCAT(username) AS userDetail,COUNT(*) AS totalUsers,SUM(age) AS sunAge,MAX(age) AS maxAge,MIN(age) AS minAge,AVG(age) AS avgAge FROM user1 WHERE id >= 2 GROUP by addrORDER BY avgAge         HAVING avgAge>17;   

Answer 1

HAVING放在ORDER BY前面GROUP BY后面。