inblog logo
|
stupefyee
    SQL문제풀기

    [SQL 문제 풀이] Customers Who Bought All Products (모든 제품을 구매한 고객)

    Stupefyee's avatar
    Stupefyee
    Jun 16, 2025
    [SQL 문제 풀이] Customers Who Bought All Products (모든 제품을 구매한 고객)
    Contents
    내가 작성한 쿼리
    Customers Who Bought All Products - LeetCode
    Can you solve this real interview question? Customers Who Bought All Products - Table: Customer +-------------+---------+ | Column Name | Type | +-------------+---------+ | customer_id | int | | product_key | int | +-------------+---------+ This table may contain duplicates rows. customer_id is not NULL. product_key is a foreign key (reference column) to Product table.   Table: Product +-------------+---------+ | Column Name | Type | +-------------+---------+ | product_key | int | +-------------+---------+ product_key is the primary key (column with unique values) for this table.   Write a solution to report the customer ids from the Customer table that bought all the products in the Product table. Return the result table in any order. The result format is in the following example.   Example 1: Input: Customer table: +-------------+-------------+ | customer_id | product_key | +-------------+-------------+ | 1 | 5 | | 2 | 6 | | 3 | 5 | | 3 | 6 | | 1 | 6 | +-------------+-------------+ Product table: +-------------+ | product_key | +-------------+ | 5 | | 6 | +-------------+ Output: +-------------+ | customer_id | +-------------+ | 1 | | 3 | +-------------+ Explanation: The customers who bought all the products (5 and 6) are customers with IDs 1 and 3.
    Customers Who Bought All Products - LeetCode
    https://leetcode.com/problems/customers-who-bought-all-products/description/
    Customers Who Bought All Products - LeetCode
    notion image
    고객 테이블에서 모든 제품을 구매한 고객 ID를 보고하는 솔루션을 작성하세요. 결과 테이블을 순서에 상관없이 반환하세요.
     

    내가 작성한 쿼리

    MySQL, Oracle

    SELECT customer_id FROM Customer GROUP BY customer_id HAVING COUNT(DISTINCT product_key) = (SELECT COUNT(*) FROM Product);
    Share article
    Contents
    내가 작성한 쿼리

    stupefyee

    RSS·Powered by Inblog