Solution for QID #113861: Create stored procedure which calls a function within using | StudyHelpMe

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. 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. Create function called 'MUL' inside the stored procedure to give the final output called 'Amount' = QuotedPrice*QuantityOrdered Show the final output for  get_Amount(1026,22,1)