SQL/LeetCode

[LeetCode] 1045. Customers Who Bought All Products

yeyeyep 2025. 2. 19. 15:05

 

 

[문제]

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

 

 

[MySQL]

SELECT customer_id
FROM Customer
GROUP BY customer_id
HAVING COUNT(DISTINCT product_key) = (SELECT COUNT(*) FROM Product)