Question paper (build 07.05.20.19)
21
222
19
20
=27
11
Phạm Thị Thuỷ
392000.00
26
Đỗ Văn Đức
294000.00
Bùi Thị Ngọc
0.00
22
14
Bùi Văn Lâm
0.00
23
18
Phạm Văn Long
0.00
24
19
Đỗ Thị Hằng
0.00
25 24
Lê Minh Hoàng
0.00
25
26
36
Nguyễn Hoài P..
0.00
27
43
Nguyễn Lan Hư... 0.00
6 of 6
Paper No: 10
Picture 6.1
Question 7:
Write an SQL query to analyze customer spending trends between 2023 and 2024 based on
completed orders. For each customer who placed completed orders in both 2023 and 2024,
calculate and display:
- CustomerID
- FullName
