mysql - 订购一个有序的sql查询

Question

所以我有这个查询来获取订单最多的 8 艘船，在这个查询之后我想让他们按 ID 排序

SELECT Shippers.ShipperName,COUNT(Orders.OrderID) AS NumberOfOrders 
FROM Shippers
LEFT JOIN Orders 
ON Orders.ShipperID=Shippers.ShipperID
GROUP BY ShipperName
ORDER BY NumberofOrders DESC
LIMIT 8;

Answer 1

使用子查询:

SELECT ShipperName, NumberOfOrders
FROM (SELECT s.ShipperName, s.ShipperId, COUNT(o.OrderID) AS NumberOfOrders 
      FROM Shippers s LEFT JOIN
           Orders o
           ON o.ShipperID = s.ShipperID
      GROUP BY ShipperName, s.ShipperId
      ORDER BY NumberofOrders DESC
      LIMIT 8
     ) s
ORDER BY ShipperId;