Question paper (build 07.05.20.19)
7 of 7
Paper No: 10
Month
NumberOfOrders Total Revenue
12
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
525000.00
12
12/2023 0
0.00
Picture 8.1
Question 9:
Create a trigger named trg_Update TotalAmount on the OrderDetails 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
