29
31
22223323333
26 10111240
2
41051230031 2
NULL
2000000.00
27 10111240
7
41051230244 4
NULL
1650000.00
28 10111240
16
41051230041 1
NULL
1000000.00
10111241
3
41051230032 2
NULL
1800000.00
30 10111241
5
41051230026 2
NULL
2000000.00
10111241
11
41051230060 1
NULL
7600000.00
10111242
16
41051230158 5
NULL
3200000.00
10111243
13
41051230034 6
NULL
800000.00
34
10111244
3
35 10111244
10
36
10111245
12
41051230025 1
41051230142 2
41051230038 2
NULL
1800000.00
NULL
NULL
6500000.00
1000000.00
Picture 9.1
Question 10:
[0.5] Create a function named f_tk. This function has an input parameter(@mechaniclD
decimal(18,0)) and return a table. The retured table includes mechanicID, mechanicName,
sumHours. Note: sumHours is the total working hours of the given mechanic's id
For example, when we execute the function f_tk by using the following statements, the result
should be as in the following figure:
select from f_tk(41051230025)
1
Results Messages
sumHours
mechanicID mechanicName
41051230025 | Cao Xuân Trường 6
Zoom
100%
Picture 10.1
Close
