Create stored procedures required for the following business requirements. Submit ONE document with the create commands in it (file name: LastName_HW2.sql). This file would also hold a test snippet (execute command) for EACH procedure. Make sure to comment out the test snippets (using multi-line comments).

The user should be able to update the approved date of an existing purchase order.

The user should be able to calculate the final price (quantity * unitcost) for an order detail for which an order detail ID has been provided.

The user should be able to calculate the entire total of an order by calculating the totals of all the order details for that order.

The user would like to see the most valuable supplier by finding which supplier provides the highest number of individual products to Northwind Traders. The results should show the company, the last name and the state of the supplier in addition to the number of individual products supplied by the supplier.