题解 | #纠错3#
纠错3
https://www.nowcoder.com/practice/3870c9bca7a4406f899af3e903b8bf51
本题应是按照订单号进行分组而非各个订单的数量
SELECT order_num, COUNT(*) AS items FROM OrderItems GROUP BY order_num HAVING COUNT(*) >= 3 // 分组计算那些超过3单的订单号 ORDER BY items, order_num; // 根据订单数量以及订单号排序