GROUP BY 属性名 [HAVING 条件表达式][WITH ROLLUP]
HAVING 条件表达式限定显示的结果
WITH ROLLUP 在最后会加上记录上面的总和
AND OR : 逻辑连接词
IN
BETWEEN AND
LIKE
IS
DISTINCT
GROUP BY
HAVING
GROUP BY 属性名 [HAVING 条件表达式][WITH ROLLUP]
HAVING 条件表达式限定显示的结果
WITH ROLLUP 在最后会加上记录上面的总和
AND OR : 逻辑连接词
IN
BETWEEN AND
LIKE
IS
DISTINCT
GROUP BY
HAVING