# $1045. 买下所有产品的客户
# https://leetcode-cn.com/problems/customers-who-bought-all-products/

# SQL架构
Create table If Not Exists Customer (customer_id int, product_key int);
Create table Product (product_key int);
Truncate table Customer;
insert into Customer (customer_id, product_key) values ('1', '5');
insert into Customer (customer_id, product_key) values ('2', '6');
insert into Customer (customer_id, product_key) values ('3', '5');
insert into Customer (customer_id, product_key) values ('3', '6');
insert into Customer (customer_id, product_key) values ('1', '6');
Truncate table Product;
insert into Product (product_key) values ('5');
insert into Product (product_key) values ('6');

# Write your MySQL query statement below
select
    customer_id
from
    Customer
group by
    customer_id
having
    count(distinct product_key) = (
        select
            count(distinct product_key)
        from
            Product
    );

# clean-up
drop table Customer;
drop table Product;