PE_-_DBI_-_02_-_SP_2024_-_Block_10_1501.webp

Results Messages
NumberOfOrders
1 134
Picture 9.1
Question 10:
Create a function named OrderPrice to calculate the sum of list_price in table order_items,an input paramater is @orderld (int) and the output of the function is a decimal value.
For example, when we execute the function OrderPrice using the following statements, the result should be as in the following figure:
SELECT [dbo]. OrderPrice (3) AS sum_of_list_price
Results
Messages
sum of list price
1600
1
Picture 10.1
Zoom

+ 100%
Close