Create stored procedure which calls a function within using the steps below: Create stored procedure get_Amount() with 3 input parameters - CustomerID, OrderNumber and ProductNumber

Subject:Computer SciencePrice: Bought3

Share With

Create stored procedure which calls a function within using the steps below:

1. Create stored procedure get_Amount() with 3 input parameters - CustomerID, OrderNumber and ProductNumber.
2. Use the following tables [customers, order and order_details tables] to create the select statement for the procedure to get the quoted price and quantity ordered.
3. Create function called 'MUL' inside the stored procedure to give the final output called 'Amount' = QuotedPrice*QuantityOrdered
4. Show the final output for 

get_Amount(1026,22,1)