SELECT order_num, COUNT(*) AS items FROM OrderItems GROUP BY order_num HAVING COUNT(*) >= 3 // 分组计算那些超过3单的订单号 ORDER BY items, order_num; // 根据订单数量以及订单号排序