3 of 3
Paper No: 11
EmployeeID FullName
Role
1
1
Nguyễn Văn An
HireDate Salary
Manager 2021-02-15 18000000.00
23
6
10
Nguyễn Thanh Tùng
Phạm Quốc Việt
Chef
Chef
2021-11-20 18500000.00
2021-08-09 19000000.00
Picture 2.1
Question 3:
Write an SQL query to display the list of customers who made reservations in the year 2025
and were assigned to tables whose locations include "Khu A". Display the results with
CustomerID, FullName, Reservation Time, TableID, Location, as shown in the following
figure:
CustomerID
1
40
FullName
Đỗ Hoàng Vũ
2
13
3
4
5
6
7
8
9
112
10
2204277332
28
28
10
Võ Thị Hoa
Bùi Ngọc Linh
Bùi Ngọc Linh
Lê Văn Phú
46
44
44
Phạm Văn Quang
Nguyễn Lan Hương
Trän Huu Nghĩa
Trần Hữu Nghĩa
Đỗ Thị Hiền
Đỗ Thị Hiền
Phạm Ngọc Bảo
Zoom
+ 100%
TableID Location
Reservation Time
2025-11-21 19:02:00.000 2
2025-03-02 12:00:00.000 3
2025-01-01 19:15:00.000 2
2025-01-01 19:15:00.000 3
2025-07-13 12:30:00.000 2
2025-09-19 19:15:00.000 2
2025-01-08 19:15:00.000 3
2025-05-23 20:00:00.000 2
2025-05-23 20:00:00.000 3
2025-06-16 20:00:00.000 3
2025-10-13 13:00:00.000 1
2025-02-13 13:00:00.000 2
Khu A - Trung tâm
Khu A - Góc phải
Khu A - Trung tâm
Khu A - Góc phải
Khu A - Trung tâm
Khu A - Trung tâm
Khu A - Góc phải
Khu A - Trung tâm
Khu A - Góc phải
Khu A - Góc phải
Khu A - Gần cửa sổ
Khu A - Trung tâm
Close
