Create the following objects in the AdventureWorks database:

A stored procedure to return the sales for a specific sales person. The stored procedure should accept parameters of the ID of the Sales Person a StartDate & and EndDate. It should return the Store Name, the number of items sold and the Sales Person's name.

A function to return all the phone numbers for the ID of a person. The function should accept a parameter of the person's ID$.$

A view to return the most expensive item sold for each store.

A trigger against the Production.ScrapReason table to prevent changes when the ScrapReason is "Holiday"