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 servicel mechanicID hours comment rate
1 10111231
1
41051230025 3 NULL 100000000
10111231
41051230025 2 NULL
200000000
10111231
41051230026 1 NULL
180000000
10111232
41051230027 2 NULL
18800000.00
10111232
41051230031
NULL
10111232
12
41051230032 2 NULL
100000000
10111233
7
41051230033 5 NULL
1650000.00
10111233 8
41051230033 1 NULL
380000000
10111233
9
41051230033
NULL 400000000
10 10111234
10
41051230034 2 NULL
650000000
11 10111235
1
41051230038
NULL
100000000
12 10111235
2
41051230039 1 NULL
200000000
13 10111235
11
41051230035 2 NULL
760000000
14 10111236
1
41051230041 1 NULL
100000000
15 10111236
13
41051230040 2 NULL
800000.00
16 10111236
15
41051230041 3
NULL
680000000
17 10111237
5
41051230032 2 NULL
18 10111237
10
41051230062 3 NULL
650000000
19 10111238
2
41051230143 1 NULL
20 10111238
7
41051230244 3 NULL
165000000
21 10111238 12
41051230142
NULL
100000000
22 10111238 15
23 10111239
4
41051230159 5 NULL
41051230245 2 NULL
680000000
18800000.00
Query executed successfully.
LAPTOP-DLNBKBOR (12.0 RTM) sa (54) Car Dealership 00:00:00 33 rows
Picture 9.1
Question 10:
[1] Write a query to reduce the retail price of unused parts by 10%.
Zoom
100%
Close
