phone
nvarchar(20)
has
Employees
N
works
Shits
smp: int
FulName
marchar(00)
gender
cha)
Picture 1.1
abit int
shitDate date
startTime
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: 5
EmployeelD FullName
Role
HireDate Salary
1
1
Nguyễn Văn An
Manager 2021-02-15 18000000.00
2
6
Nguyễn Thanh Tùng
Chef
2021-11-20 18500000.00
3
10
Phạm Quốc Việt
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:
CustomerID FullName
ItemID ItemName
1
36
2
36
Nguyễn Hoài Phương 3
Nguyễn Hoài Phương 5
3
36
30
Nguyễn Hoài Phương 11
1:
"
Bún chả Hà Nội
Cơm rang dưa bò
Nộm đu đủ bò khô
Zoom
+ 70%
Close
