8 of 8
Paper No: 1
Results
Messages
number of service ticket
1
2
Picture 8.1
Question 9:
[1] Write a query to delete from the table ServiceMehanic all rows corresponding to service belonging to the serviceID having serviceID = 16
Results Messages service TicketID servicelD mechanicID
1 10111231
hours comment rate
41051230025 3 NULL
100000000
2
10111231
41051230025 2 NULL
10111231
41051230026
NULL
180000000
10111232
41051230027 2
NULL
18800000.00
10111232
5
41051230031
NULL
10111232
12
41051230032 2 NULL
100000000
10111233
7
41051230033 5 NULL
165000000
10111233 8
41051230033
NULL
380000000
10111233
41051230033
NULL
400000000
10 10111234
10
41051230034 2
NULL
650000000
Zoom
+ 100%
Close
