execute MonthlySalesSummary 2023
7 of 7
Paper No: 5
Month
NumberOfOrders Total Revenue
1
1/2023 1
475000.00
2
2/2023 0
0.00
3
3/2023 4
3315000.00
4
4/2023 2
1390000.00
5
5/2023 1
575000.00
6
6/2023 4
2115000.00
7
7/2023 1
1105000.00
8
8/2023 1
1070000.00
9
9/2023 1
347000.00
10 10/2023 2
2111000.00
11
11/2023 1
12
12/2023 0
525000.00
0.00
Picture 8.1
Question 9
Create a trigger named rg_update iotavamount on the Uroeruetais table to ensure the
TotalAmount column in the Orders table always stays accurate.
Whenever an OrderDetails record is inserted, updated, or deleted, the trigger should
automatically recalculate the total amount of the affected ardars as the sum of (Quantity
File) for all
f Grum Duis ul and are to, tual aunt of th
order should be set to 0.
Zoom
+ 56%
Close
