Files
leetcode/586-customer-placing-the-largest-number-of-orders/586-customer-placing-the-largest-number-of-orders.sql

6 lines
146 B
SQL

# Write your MySQL query statement below
SELECT customer_number
FROM Orders
GROUP BY customer_number
ORDER BY count(customer_number) DESC
LIMIT 1;