completed orders. For each customer who placed completed orders in both 2024 and 2025,
calculate and display:
- CustomerID
- FullName
6 of 6
Paper No: 11
- Avg TotalOrderValue2024 - the average total order value of the customer's completed
orders in 2024, rounded to two decimal places.
- Avg TotalOrderValue2025 - the average total order value of the customer's completed
orders in 2025, rounded to two decimal places.
- PercentageChange - the percentage growth in the average total order value from 2024 to
2025. Il is calculated as (Avg TotalOrderValue2025 - Avg Total OrderValue2024)/
Avg TotalOrderValue2024*100. Round the percentage change to two decimal places, and
append %' at the end.
Order the result in ascending order of CustomerID as shown in the following figure.
Avg TotalOrderValue2024 Avg TotalOrderValue2025 PercentageChange
CustomerID
1
2
FullName
Trần Văn Tâm
340000.00
481000.00
41.47%
2
4
Phạm Văn Cường
341000.00
592500.00
73.75%
3
10
Lê Văn Phú
370000.00
875000.00
136.49 %
4
12
Đỗ Đức Thịnh
525000.00
570000.00
8.57%
5
13
Vô Thị Hoa
446000.00
637500.00
42.94 %
6
17
Lê Thị Diễm
235000.00
920000.00
7
20
Võ Quốc Huy
240000.00
535000.00
8
22
Nguyễn Văn Tín
890000.00
900000.00
291.49 %
122.92%
1.12%
9
25
Phạm Thị Hậu
504000.00
493000.00
-2.18 %
+100%
Zoom
- FUO
Close
