So if I say " the trigger will fire when a record is added or removed from the table ingredient" is not 100% correct. Because it depends on what's inside...

CREATE TRIGGER trg_minimalNumberIngredientsForRecipe ON ingredients

AFTER DELETE,INSERT

AS

BEGIN

IF EXISTS

(

SELECT recipeNumber

FROM ingredients

GROUP BY recipeNumber

...

I started with a small idea. I know how to check for one row, if 1 row is inserted, but I don't know

how to do it for severel sets....

I am trying to solve possible constraints that my coming test at my study might ask, that could be implemented with Trigger, check constraints or stored procedures.

Your question: Also what...