HAVING 字句只有配合GROUP BY使用 才有意义
例子
SELECT sex, GROUP_CONCAT(name) AS users,
COUNT(*) AS total
FROM user
WHERE id > 0
GROUP BY sex
HAVING COUNT(*)>2 AND MAX(age)>18;