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
2025-09-09 13:00:00.000 3
2025-03-26 19:45:00. 000 2.
2025-03-26 19:45:00.000 3
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
Khu A - Góc phải
Khu A - Trung tâm
Khu A - Góc phải
32204277332244
13
Võ Thị Hoa
28
28
10
46
28
Bùi Ngọc Linh
Bùi Ngọc Linh
Lê Văn Phú
Phạm Văn Quang
Nguyễn Lan Hương
Trần Hữu Nghĩa
Trän Huu Nghĩa
Đỗ Thị Hiền
Đỗ Thị Hiền
Phạm Ngọc Bảo
Bùi Ngọc Linh
Phạm Văn Cường
Phạm Văn Cường
Picture 3.1
9
10
23456781222315
Question 4:
Write an SQL query to list all tables whose locations include "Khu A", "Khu B" or "Khu C",
along with the customers who reserved them in September 2025. Ensure to include tables
even if no customer reserved them during that month. Show the following columns: TableID,
Capacity, Location, CustomerID, FullName. Sort the result in descending order of Capacity
and then by Location in ascending order for tables with the same capacity.
Zoom
+ 100%
Close
