Please write SQL Query for following questions using Northwind Database:

1. Create a procedure to add a new record to Territories table. Call it NewTerr. Add the following records using the procedure.

TerritoryID	TerritoryDescription	Region
88888	Brooklyn	1
99999	Waco	4
77777	Long Beach	2

2. Create an Update Procedure that will change the Region from 1 to 3 for record with TerritoryID 88888. Call it Update88.

3. Create a Delete Procedure that will delete the one record from the Territories table that has Waco in the TerritoryDescription.

4. Define a trigger. Give an example when it should be used.