• Excellent question.

    First because it demonstrates the MERGE,

    Second because it illustrates the $action, and

    Last because the format for the output makes the answer particularly clear.

    Specifically:

    INSERT6ProductionJonesNULLNULLNULL

    UPDATE2SalesErickson2SalesByham

    DELETENULLNULLNULL5ManufacturingBrewer

    Nice one!

    Jamie