README.md

586. 订单最多的客户

English Version

题目描述

None

解法

SQL

SELECT customer_number
FROM 
    (SELECT customer_number,
         count(*) AS total
    FROM orders
    GROUP BY  customer_number
    ORDER BY  total DESC limit 1) tmp