Each row of the SalesOrderDetail table represents a particular line item for an order. It indicates which item (ProductID) and how many (OrderQty). Create a stored procedure that accepts a parameter ProductID and has an OUTPUT parameter that returns the total number sold for that product (across all orders). Make use of the Sales.SalesOrderDetail table to accomplish this.

2a) What is the SQL to create this stored procedure? (Hint: Start by first writing a query that does what you want for some fixed product id. Then convert that query into a stored procedure that uses the parameter for the input)

2b) Provide an example to execute your stored procedure.