2025.01.15(수) 1일 1쿼리

 

Quiz 1) 가장 구매건이 많은 회원 뽑기

 

SELECT 
  o.customer_id as 'ID', 
  c.name, 
  count(order_id) as '총 주문 건수' 
FROM customers AS c
JOIN orders AS o ON c.customer_id = o.customer_id
GROUP BY c.customer_id
ORDER BY count(order_id) DESC
LIMIT 1;

 

결과 화면