customer-placing-the-largest-number-of-orders.sql (199B)
1 --Runtime: 853ms Beats 79.3% 2 --Return the customer with the most number of orders 3 SELECT O.customer_number 4 FROM Orders AS O 5 GROUP BY O.customer_number 6 ORDER BY count(O.customer_number) DESC 7 LIMIT 1 8