CustomerID FullName
Order the result in ascending order of CustomerID as shown in the following figure.
Avg TotalOrderValue2024 Avg TotalOrderValue2025 PercentageChange
1
2
2
4
Trần Văn Tâm
340000.00
481000.00
Phạm Văn Cường
341000.00
592500.00
41.47%
73.75%
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19 48
2222222 3 5 3 3 3 4 4 4%
10
Lê Văn Phú
370000.00
875000.00
136.49 %
12
Đỗ Đức Thịnh
525000.00
570000.00
8.57 %
13
Võ Thị Hoa
446000.00
637500.00
17
Lê Thị Diễm
235000.00
920000.00
42.94%
291.49%
20
Võ Quốc Huy
240000.00
535000.00
122.92%
Nguyễn Văn Tín
890000.00
900000.00
1.12%
25
Phạm Thị Hậu
504000.00
493000.00
-2.18%
26
Đỗ Văn Đức
395000.00
294000.00
-25.57 %
30
Tran Thi Tudi
460000.00
892 100.00
94.02 %
Lê Đức Hòa
481000.00
483J57.14
0.59%
35
Bùi Thị Trang
403333.33
577500.00
39
Phạm Thị Yến
578000.00
629500.00
43.18 %
8.91%
40
Đỗ Hoàng Vũ
330000.00
754000.00
128.48 %
41
Võ Thị Kim
880000.00
480000.00
-45.45%
45
Lê Thị Tâm
1102000.00
655000.00
-40.56%
46
Phạm Văn Quang 590000.00
657500.00
11.44%
Võ Đức Tài
255000.00
795000.00
211.76 %
Picture 7.1
Question 8:
Write a stored procedure named MonthlySalesSummary that generates a monthly sales
report for a specified year. Your procedure must accept one input parameter: @year int - the
year for which the report will be generated. The procedure must display all 12 months (from
January to December), even if there are no orders in a given month. For each month,
calculate and display:
-Month in the format Month/Year
- NumberOfOrders - the total count of completed orders in that month
- TotalRevenue - the total revenue (sum of Quantity * Price) from all completed orders in that
month
Zoom
For example, when we execute the MonthlySalesSummary procedure by using the following
+100%
Close
