2022-12-17：订单最多的客户。以下数据，结果输出 3。请问 sql 语句如何写？ DROP TABLE IF EXISTS `orders`； CREATE TABLE `orders` ( `

DROP TABLE IF EXISTS `orders`;CREATE TABLE `orders` (  `order_number` int(11) NOT NULL,  `customer_number` int(11) NOT NULL,  PRIMARY KEY (`order_number`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `orders` VALUES ('1', '1');INSERT INTO `orders` VALUES ('2', '2');INSERT INTO `orders` VALUES ('3', '3');INSERT INTO `orders` VALUES ('4', '3');

SELECT    customer_numberFROM    ordersGROUP BY customer_numberORDER BY COUNT(*) DESCLIMIT 1