题28: 找到下表中订单数最多客户对应的customer-number,(数据保证订单数最多的顾客恰好只有一位)。 解题思路: (1)使用GROUP BY对customer_number进行分组, (2)进行降序排列 (3)用LIMIT找到最大的订单数。 SELECT customer_number FROM orders GROUP BY customer_number ORDER BY COUNT(*) DESC LIMIT 0, 1;