Paper No: 1
Results
Messages
mechanic Name
sum Hours
4
2
1
2
1
7
Bùi Văn Nhật
Cao Văn Minh
Lê Hào
Mai Huy An
Ngô Đăng Khoa
Ngô Mạnh Quỳnh
Trường Xuân Đức 5
Picture 5.1
1
2
3
4
5
6
7
Question 6:
[1] Write a query to retrieve id and name of all parts and the total amount paid of the used part(if any). Accept NULL if the part has not been used.
Results
Messages
partID
101
102
part Name
SumOf Used Price
Ac quy
1750000.00
Dầu trợ lực lái
310000.00
1
2
Zoom
+ 100%
Close