RelationalDesign: dml_nutritioneer_calculations_0.1.sql

UPDATE recipe
SET kcal_sum = (
    SELECT SUM(ingredient.kcal * recipe_contains_ingredient.ingredient_quantity / 100)
    FROM recipe_contains_ingredient, ingredient
    WHERE recipe_contains_ingredient.ingredient_name = ingredient.name
      AND recipe_contains_ingredient.recipe_id = recipe.id
);