Lopsided Recipes

Problem

Table: `RecipeLines`

```text
+--------------+------+
| Column Name | Type |
+--------------+------+
| recipe_id | int |
| ingredient_id| int |
| grams | int |
+--------------+------+
(recipe_id, ingredient_id) is the primary key for this table.
Each row gives how many grams of one ingredient a recipe uses.
```

A recipe is called **lopsided** when its single heaviest ingredient (its maximum grams) is strictly greater than the largest average-grams figure found among all recipes, where each recipe's average is taken over its own ingredients, and the comparison includes the recipe itself.

Write a solution to find the `recipe_id` of every lopsided recipe.

Return the result table in any order.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns recipe_id.

Starter code (SQL)

SELECT *
FROM RecipeLines;

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