Ingredients Frequently Used Together

Problem

Table: `recipe_uses`

```text
+-------------+------+
| Column Name | Type |
+-------------+------+
| cook_id | int |
| item_id | int |
| grams | int |
+-------------+------+
There is no single-column primary key. Each row means a cook used a given
pantry item in one of their recipes.
```

Table: `pantry_items`

```text
+-------------+---------------+
| Column Name | Type |
+-------------+---------------+
| item_id | int |
| aisle | varchar |
| unit_cost | decimal(10,2) |
+-------------+---------------+
item_id is the primary key for this table.
```

Find every pair of pantry items that were used together by at least three different cooks. Treat each pair only once, with the smaller `item_id` first. Return the two item ids, the aisle of each item, and the number of distinct cooks who used both.

Return `item1_id`, `item2_id`, `item1_aisle`, `item2_aisle`, and `cook_count`, ordered by `cook_count` descending, then `item1_id` ascending, then `item2_id` ascending.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns item1_id, item2_id, item1_aisle, item2_aisle, cook_count.

Starter code (SQL)

SELECT *
FROM recipe_uses;

Related SQL questions

• 3-Day Tweet Rolling AverageMedium
• 7-Day vs 28-Day Rolling Avg DivergenceMedium
• A/B Test Sample Ratio Mismatch (SRM) CheckMedium
• Accounts Streaming From Two Devices at OnceMedium
• Ad Campaign Funnel AnalysisMedium
• Agent Resolution RateMedium