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
- 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.
Step by Step Solution
★★★★★
3.62 Rating (152 Votes )
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
