leetcode-586. 订单最多的客户

586. 订单最多的客户 - 力扣(Leetcode)

# Write your MySQL query statement below

select customer_number from (
    select customer_number, count(*) cnt from Orders group by customer_number
) cus order by cnt desc limit 1
posted @ 2023-01-01 12:03  吴丹阳-V  阅读(20)  评论(0)    收藏  举报