Loading problem...
You are given two relational tables.
Customer captures purchase events:
Product captures the full catalog:
A customer is considered fully covered if they have purchased every product listed in Product at least once.
Task:
Supported submission environments:
Customer:
| customer_id | product_key |
|-------------|-------------|
| 1 | 5 |
| 2 | 6 |
| 3 | 5 |
| 3 | 6 |
| 1 | 6 |
Product:
| product_key |
|-------------|
| 5 |
| 6 |[
{"customer_id":1},
{"customer_id":3}
]Explanation
Customers 1 and 3 each purchased both required products.
Customer:
| customer_id | product_key |
|-------------|-------------|
| 10 | 100 |
| 10 | 100 |
| 11 | 100 |
| 11 | 101 |
Product:
| product_key |
|-------------|
| 100 |
| 101 |[
{"customer_id":11}
]Explanation
Duplicates for customer 10 do not compensate for missing product 101.
Customer:
| customer_id | product_key |
|-------------|-------------|
| 7 | 1 |
| 8 | 2 |
Product:
| product_key |
|-------------|
| 1 |
| 2 |[]Explanation
No customer covers the entire catalog.
Constraints