Part 1 Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID value passed into the function. If the result is a NULL return a zero. Take a screen shot of the SQL windows and results and paste it here.

Part 2 Using the WideWorldDistributors database and the Sales schema write a query that returns InvoiceID, InvoiceDate and CustomerPurchaseOrderNumber from the table Invoices and the result of the above created function. Take a screen shot of the SQL windows and results and paste it here.

Part 3 Using the AdventureWorks database and the Production schema create a function that takes ProductId as an input parameter and returns the results of a query that retrieves ProductID, Name, Color, Weight, and DaysToManufacgture from the table Product. Take a screen shot of the SQL windows and results and paste it here

Part 4 Using the AdventureWorks database and the Production schema write a query that returns the results of the function in Part 3 for ProductID 320. Take a screen shot of the SQL windows and results and paste it here.

Part 5 Using the AdventureWorks database and the Production schema write a query that returns the results of the function in Part 3 for ProductID 15. Take a screen shot of the SQL windows and results and paste it here.