with rollup出错问题

数据表是老师上课的数据表，在不用with rollup时，是可以正常使用的，当加上了with rollup就提示

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ROLLUP' at line 1

命令如下：

SELECT sex,GROUP_CONCAT(username), COUNT(*),

SUM(salary),MAX(salary),MIN(salary),AVG(salary)FROM user1 GROUP BY sex

WITH ROLLUP;