Question 4:
[1] Write a query to display custName, model, service TicketID, dateReturned of the car(s)
whose dateReturned is 1st quarter of 2021.
Results Messages
custName
model
service TicketID
1
Phạm Nguyễn Dũng | dodge
10111243
dateReturned
2021-01-07
2
Đoàn Minh Đạo
audi
10111239
2021-03-16
3
Hồ Đức Trung Hữu
chevrolet
10111237
2021-03-20
4
Nguyễn Thị Minh Hà
toyota
10111235
2021-03-29
5
Phạm Nguyên Dũng
chevrolet
10111231
2021-02-07
5 of 5
Paper No: 1
Picture 4.1
Question 5:
[1] Write a query to display the most working hours of the mechanic in 2021. The result
includes columns: mechanicName, sumHours
mechanicName
sumHours
1
| Nguyễn Văn Linh
8
Picture 5.1
Zoom
Question 6:
[1] Create a stored procedure named proc_service Ticket_part to count distinct parts
belonging to a given service ticket
100%
Close
