Please write SQL Query for following questions using Northwind Database:

1. In the "Query Designer" window write and execute the CREATE VIEW statement to create the view object called CustEmployee. Using CustomerID ContactName, EmployeeID, EmployeeLastName, EmployeeFirstName

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