题解 | #纠错3#

SELECT order_num, COUNT(order_num) AS items 
FROM OrderItems 
GROUP BY order_num  --只修改了该处
HAVING COUNT(order_num) >= 3 
ORDER BY items, order_num;

可以看出是计算order num 出现的次数，所以是按照order_num分组