LeetCode_Study_Plan/SQL

586. Customer Placing the Largest Number of Orders mysql

개발하는루루 2022. 10. 2. 14:44

https://leetcode.com/problems/customer-placing-the-largest-number-of-orders/?envType=study-plan&id=sql-i 

 

Customer Placing the Largest Number of Orders - LeetCode

Level up your coding skills and quickly land a job. This is the best place to expand your knowledge and get prepared for your next interview.

leetcode.com

select customer_number 
from 
(select customer_number, count(order_number) as cnt from orders group by customer_number) tb order by tb.cnt desc limit 1;