这段语句中为什么 老是报错 ‘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 addr

ORDER BY avgAge         

HAVING avgAge>17;   

Answer 1

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