Question paper (build 07.05.20.19)
Employees
emplo: int
FullName:
nvarchar(60)
gender
char(1)
Picture 1.1
time
endTime: time
Question 2:
Write an SQL query to display all employees who are chefs or managers and were hired in
2021, as shown in the following figure:
3 of 3
Paper No: 10
EmployeeID FullName
Role
HireDate Salary
1
1
2
6
3
10
Nguyễn Văn An
Nguyễn Thanh Tùng
Phạm Quốc Việt
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
Phương", displaying the CustomerID, FullName, ItemID, and ItemName. Ensure that
duplicate records are not repeated in the result:
