# 1045. Customers Who Bought All Products

<https://leetcode.com/problems/customers-who-bought-all-products>

## Description

Table: `Customer`

```
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| customer\_id | int     |
| product\_key | int     |
+-------------+---------+
product\_key is a foreign key to Product table.
```

Table: `Product`

```
+-------------+---------+
| Column Name | Type    |
+-------------+---------+
| product\_key | int     |
+-------------+---------+
product\_key is the primary key column for this table.
```

Write an SQL query for a report that provides the customer ids from the `Customer` table that bought all the products in the `Product` table.

Return the result table in **any order**.

The query result format is in the following example:

```
Customer table:
+-------------+-------------+
| customer\_id | product\_key |
+-------------+-------------+
| 1           | 5           |
| 2           | 6           |
| 3           | 5           |
| 3           | 6           |
| 1           | 6           |
+-------------+-------------+
Product table:
+-------------+
| product\_key |
+-------------+
| 5           |
| 6           |
+-------------+
Result table:
+-------------+
| customer\_id |
+-------------+
| 1           |
| 3           |
+-------------+
The customers who bought all the products (5 and 6) are customers with id 1 and 3.
```

## ac

```java
```
