# 586. 订单最多的客户
# https://leetcode-cn.com/problems/customer-placing-the-largest-number-of-orders/

# SQL架构
Create table If Not Exists orders (order_number int, customer_number int);
Truncate table orders;
insert into orders (order_number, customer_number) values ('1', '1');
insert into orders (order_number, customer_number) values ('2', '2');
insert into orders (order_number, customer_number) values ('3', '3');
insert into orders (order_number, customer_number) values ('4', '3');

# Write your MySQL query statement below
select
    customer_number
from
    orders
group by
    customer_number
order by
    count(*) desc
limit
    1;

# clean-up
drop table orders;