Write a script that creates and calls a stored function named item_total that calculates the total amount
Fantastic news! We've Found the answer you've been seeking!
Question:
- Write a script that creates and calls a stored function named item_total that calculates the total amount of an item in the Order_Items table (discount price multiplied by quantity). To do that, this function should accept one parameter for the item ID, it should use the discount_price function that you created in exercise 2, and it should return the value of the total for that item. Execute the query and take a screenshot of the query and the results.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: