Update
Update LargeWild
Set FallowDeer = 1
where Deer > 600
Delete
Delete from SmallWild
Where WildRabbits = 0
Merge
MERGE ForestDistricts AS FD
USING (SELECT Moose, Deer FROM LargeWild) AS LW
ON LW.LW_ID=FD.ForestID
WHEN MATCHED AND FD.ForestDistrict = 'Olsztyn' THEN DELETE
WHEN MATCHED AND FD.HuntingDistrict is null THEN
UPDATE SET FD.ForestDistrict = 'n/a'
WHEN NOT MATCHED THEN
INSERT(ForestID,ForestDistrict,HuntingDistrict)
VALUES(1, 'Olsztyn', 'n/a');