customers-who-bought-all-products

java

python

python3

mysql

mssql

oraclesql

csharp

javascript

typescript

bash

swift

kotlin

dart

golang

ruby

scala

rust

racket

erlang

elixir

pythondata

postgresql

cangjie

Database

Table: <code>Customer</code>

<pre>
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| customer_id | int |
| product_key | int |
+-------------+---------+
This table may contain duplicates rows. 
<code>customer_id</code> is not NULL<code>.</code>
product_key is a foreign key (reference column) to <code>Product</code> table.
</pre>

&nbsp;

Table: <code>Product</code>

<pre>
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| product_key | int |
+-------------+---------+
product_key is the primary key (column with unique values) for this table.
</pre>

&nbsp;

Write a solution to report the customer ids from the <code>Customer</code> table that bought all the products in the <code>Product</code> table.

Return the result table in any order.

The&nbsp;result format is in the following example.

&nbsp;
Example 1:

<pre>
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.
</pre>

find_customers

Customers Who Bought All Products

<code>Customer</code>&nbsp;表：

<pre>
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| customer_id | int |
| product_key | int |
+-------------+---------+
该表可能包含重复的行。
customer_id 不为 NULL。
product_key 是 Product 表的外键(reference 列)。
</pre>

<code>Product</code>&nbsp;表：

<pre>
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| product_key | int |
+-------------+---------+
product_key 是这张表的主键（具有唯一值的列）。
</pre>

&nbsp;

编写解决方案，报告&nbsp;<code>Customer</code> 表中购买了 <code>Product</code> 表中所有产品的客户的 id。

返回结果表 无顺序要求 。

返回结果格式如下所示。

&nbsp;

示例 1：

<pre>
输入：
Customer 表：
+-------------+-------------+
| customer_id | product_key |
+-------------+-------------+
| 1 | 5 |
| 2 | 6 |
| 3 | 5 |
| 3 | 6 |
| 1 | 6 |
+-------------+-------------+
Product 表：
+-------------+
| product_key |
+-------------+
| 5 |
| 6 |
+-------------+
输出：
+-------------+
| customer_id |
+-------------+
| 1 |
| 3 |
+-------------+
解释：
购买了所有产品（5 和 6）的客户的 id 是 1 和 3 。
</pre>