[LeetCode] 586. Customer Placing the Largest Number of Orders

 

 

[문제]

이미지를 누르면 문제 링크로 넘어갑니다

 

 

[MySQL]

WITH order_cnt AS (
    SELECT customer_number
         , COUNT(DISTINCT order_number) AS cnt
    FROM Orders
    GROUP BY customer_number
) 

SELECT customer_number
FROM order_cnt
WHERE cnt = (SELECT MAX(cnt)
              FROM order_cnt)