hyezdata 님의 블로그

Customer Placing the Largest Number of Orders 본문

코딩테스트

Customer Placing the Largest Number of Orders

hyezdata 2026. 5. 22. 19:07 
# 가장 많이 주문한 customer_number 찾기
select customer_number
from orders
group by customer_number
order by count(*) desc
limit 1

 

 

 

Customer Placing the Largest Number of Orders - LeetCode

Can you solve this real interview question? Customer Placing the Largest Number of Orders - Table: Orders +-----------------+----------+ | Column Name | Type | +-----------------+----------+ | order_number | int | | customer_number | int | +---------------

leetcode.com

 

728x90
반응형

'코딩테스트' 카테고리의 다른 글

Triangle Judgement  (0) 2026.05.25
Sales Person  (0) 2026.05.25
Game Play Analysis IV  (0) 2026.05.18
Trips and Users  (0) 2026.05.11
Game Play Analysis I  (0) 2026.05.07
'코딩테스트' Related Articles more