-
586. Customer Placing the Largest Number of Orders mysqlLeetCode_Study_Plan/SQL 2022. 10. 2. 14:44
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;
'LeetCode_Study_Plan > SQL' 카테고리의 다른 글
1890. The Latest Login in 2020 mysql (0) 2022.10.02 511. Game Play Analysis I mysql (0) 2022.10.02 1729. Find Followers Count mysql (0) 2022.10.02 1693. Daily Leads and Partners mysql (0) 2022.10.02 1141. User Activity for the Past 30 Days I mysql (0) 2022.10.02