3 of 3
Paper No: 5
EmployeelD FullName
1
1
Nguyễn Văn An
2
6
3
10
Nguyễn Thanh Tùng
Phạm Quốc Việt
Role
HireDate Salary
Manager 2021-02-15 18000000.00
Chef
2021-11-20 18500000.00
Chef
2021-08-09 19000000.00
Picture 2.1
Question 3:
Write an SQL query to list all menu items ordered by the customer named "Nguyễn Hoài
Phuong", displaying the CustomerID, FullName, ItemID, and ItemName. Ensure that
duplicate records are not repeated in the result:
ItemID ItemName
CustomerID FullName
1
36
2
36
3
36
4
36
1567
Nguyễn Hoài Phương 3
Nguyễn Hoài Phương 5
Nguyễn Hoài Phương 11
Nguyễn Hoài Phương 14
36
Nguyễn Hoài Phương 15
36
36
8
36
9
36
Nguyễn Hoài Phương 23
10 36
Nguyễn Hoài Phương 26
Nguyễn Hoài Phương 16
Nguyễn Hoài Phương 17
Nguyễn Hoài Phương 19
Bún chả Hà Nội
Cơm rang dưa bò
Nộm đu đủ bò khô
Súp ngô gà
Súp nấm hải sản
Trà đá
Nước suối
Sinh tố bơ
Nước chanh
Kem dừa
Picture 3.1
Question 4:
Write an SQL query to display all main dishes (Category = "Món chinh'), along with the
customers who ordered them in August 2025. Include menu items even if they were not
ordered by any customer during that month. Show the following columns: Category, ItemID,
ItemName, CustomerID, FullName. Sort the result by ItemName in ascending order, then by
CustomerID in ascending order for rows of the same ItemName as shown in the following
figure:
Zoom
+ 70%
Close
