select number FROM grade GROUP BY number --分组 HAVING COUNT(number)>=3 --筛选符合条件的组 聚合函数不能用在where中 ORDER BY number--
运行顺序FROM → GROUP BY → HAVING → SELECT → ORDER BY
运行顺序FROM
GROUP BY
HAVING
SELECT
ORDER BY