0
From the following tables, write a SQL query to find those players who came into the field at the last time of play. Return match number, country name, player name, jersey number and time in out.
Sample table: player_in_out
match_no | team_id | player_id | in_out | time_in_out | play_schedule | play_half
----------+---------+-----------+--------+-------------+---------------+-----------
1 | 1207 | 160151 | I | 66 | NT | 2
1 | 1207 | 160160 | O | 66 | NT | 2
1 | 1207 | 160161 | I | 77 | NT | 2
1 | 1207 | 160161 | O | 77 | NT | 2
1 | 1207 | 160157 | I | 2 | ST | 2
1 | 1207 | 160154 | O | 2 | ST | 2
1 | 1216 | 160365 | I | 61 | NT | 2
1 | 1216 | 160366 | O | 61 | NT | 2
1 | 1216 | 160357 | I | 72 | NT | 2
1 | 1216 | 160363 | O | 72 | NT | 2
1 | 1216 | 160364 | I | 82 | NT | 2
1 | 1216 | 160360 | O | 82 | NT | 2
2 | 1201 | 160014 | I | 62 | NT | 2
2 | 1201 | 160019 | O | 62 | NT | 2
2 | 1201 | 160021 | I | 74 | NT | 2
2 | 1201 | 160018 | O | 74 | NT | 2
2 | 1201 | 160022 | I | 82 | NT | 2
2 | 1201 | 160023 | O | 82 | NT | 2
2 | 1221 | 160480 | I | 62 | NT | 2
2 | 1221 | 160481 | O | 62 | NT | 2
2 | 1221 | 160475 | I | 76 | NT | 2
2 | 1221 | 160473 | O | 76 | NT | 2
2 | 1221 | 160474 | I | 88 | NT | 2
2 | 1221 | 160476 | O | 88 | NT | 2
3 | 1218 | 160413 | I | 59 | NT | 2
3 | 1218 | 160412 | O | 59 | NT | 2
3 | 1218 | 160403 | I | 60 | NT | 2
3 | 1218 | 160406 | O | 60 | NT | 2
3 | 1218 | 160410 | I | 83 | NT | 2
3 | 1218 | 160411 | O | 83 | NT | 2
3 | 1224 | 160543 | I | 69 | NT | 2
3 | 1224 | 160541 | O | 69 | NT | 2
3 | 1224 | 160550 | I | 71 | NT | 2
3 | 1224 | 160546 | O | 71 | NT | 2
3 | 1224 | 160537 | I | 88 | NT | 2
3 | 1224 | 160544 | O | 88 | NT | 2
4 | 1206 | 160133 | I | 78 | NT | 2
4 | 1206 | 160136 | O | 78 | NT | 2
4 | 1206 | 160131 | I | 87 | NT | 2
4 | 1206 | 160132 | O | 87 | NT | 2
4 | 1217 | 160386 | I | 77 | NT | 2
4 | 1217 | 160381 | O | 77 | NT | 2
4 | 1217 | 160380 | I | 80 | NT | 2
4 | 1217 | 160376 | O | 80 | NT | 2
4 | 1217 | 160383 | I | 85 | NT | 2
4 | 1217 | 160391 | O | 85 | NT | 2
5 | 1204 | 160090 | I | 87 | NT | 2
5 | 1204 | 160085 | O | 87 | NT | 2
5 | 1204 | 160075 | I | 90 | NT | 2
5 | 1204 | 160086 | O | 90 | NT | 2
5 | 1204 | 160092 | I | 3 | ST | 2
5 | 1204 | 160091 | O | 3 | ST | 2
5 | 1222 | 160502 | I | 46 | NT | 2
5 | 1222 | 160498 | O | 46 | NT | 2
5 | 1222 | 160504 | I | 65 | NT | 2
5 | 1222 | 160494 | O | 65 | NT | 2
5 | 1222 | 160506 | I | 69 | NT | 2
5 | 1222 | 160505 | O | 69 | NT | 2
6 | 1212 | 160266 | I | 46 | NT | 2
6 | 1212 | 160265 | O | 46 | NT | 2
6 | 1212 | 160276 | I | 66 | NT | 2
6 | 1212 | 160269 | O | 66 | NT | 2
6 | 1212 | 160272 | I | 76 | NT | 2
6 | 1212 | 160257 | O | 76 | NT | 2
6 | 1213 | 160289 | I | 78 | NT | 2
6 | 1213 | 160293 | O | 78 | NT | 2
6 | 1213 | 160288 | I | 80 | NT | 2
6 | 1213 | 160287 | O | 80 | NT | 2
6 | 1213 | 160294 | I | 88 | NT | 2
6 | 1213 | 160290 | O | 88 | NT | 2
7 | 1208 | 160179 | I | 78 | NT | 2
7 | 1208 | 160173 | O | 78 | NT | 2
7 | 1208 | 160180 | I | 90 | NT | 2
7 | 1208 | 160174 | O | 90 | NT | 2
7 | 1223 | 160528 | I | 66 | NT | 2
7 | 1223 | 160529 | O | 66 | NT | 2
7 | 1223 | 160526 | I | 73 | NT | 2
7 | 1223 | 160519 | O | 73 | NT | 2
8 | 1205 | 160113 | I | 75 | NT | 2
8 | 1205 | 160114 | O | 75 | NT | 2
8 | 1205 | 160112 | I | 86 | NT | 2
8 | 1205 | 160096 | O | 86 | NT | 2
8 | 1205 | 160107 | I | 88 | NT | 2
8 | 1205 | 160110 | O | 88 | NT | 2
8 | 1219 | 160433 | I | 62 | NT | 2
8 | 1219 | 160435 | O | 62 | NT | 2
8 | 1219 | 160432 | I | 70 | NT | 2
8 | 1219 | 160428 | O | 70 | NT | 2
8 | 1219 | 160437 | I | 82 | NT | 2
8 | 1219 | 160436 | O | 82 | NT | 2
9 | 1215 | 160337 | I | 64 | NT | 2
9 | 1215 | 160345 | O | 64 | NT | 2
9 | 1215 | 160342 | I | 78 | NT | 2
9 | 1215 | 160335 | O | 78 | NT | 2
9 | 1215 | 160338 | I | 85 | NT | 2
9 | 1215 | 160336 | O | 85 | NT | 2
9 | 1220 | 160444 | I | 45 | NT | 1
9 | 1220 | 160446 | O | 45 | NT | 1
9 | 1220 | 160458 | I | 59 | NT | 2
9 | 1220 | 160457 | O | 59 | NT | 2
9 | 1220 | 160449 | I | 86 | NT | 2
9 | 1220 | 160455 | O | 86 | NT | 2
10 | 1203 | 160068 | I | 62 | NT | 2
10 | 1203 | 160063 | O | 62 | NT | 2
10 | 1203 | 160069 | I | 73 | NT | 2
10 | 1203 | 160067 | O | 73 | NT | 2
10 | 1203 | 160058 | I | 76 | NT | 2
10 | 1203 | 160051 | O | 76 | NT | 2
10 | 1211 | 160238 | I | 58 | NT | 2
10 | 1211 | 160237 | O | 58 | NT | 2
10 | 1211 | 160250 | I | 75 | NT | 2
10 | 1211 | 160248 | O | 75 | NT | 2
10 | 1211 | 160245 | I | 78 | NT | 2
10 | 1211 | 160242 | O | 78 | NT | 2
11 | 1202 | 160041 | I | 59 | NT | 2
11 | 1202 | 160040 | O | 59 | NT | 2
11 | 1202 | 160046 | I | 65 | NT | 2
11 | 1202 | 160045 | O | 65 | NT | 2
11 | 1202 | 160042 | I | 77 | NT | 2
11 | 1202 | 160037 | O | 77 | NT | 2
11 | 1209 | 160206 | I | 69 | NT | 2
11 | 1209 | 160207 | O | 69 | NT | 2
11 | 1209 | 160200 | I | 79 | NT | 2
11 | 1209 | 160197 | O | 79 | NT | 2
11 | 1209 | 160195 | I | 89 | NT | 2
11 | 1209 | 160204 | O | 89 | NT | 2
12 | 1210 | 160227 | I | 81 | NT | 2
12 | 1210 | 160230 | O | 81 | NT | 2
12 | 1210 | 160211 | I | 90 | NT | 2
12 | 1210 | 160229 | O | 90 | NT | 2
12 | 1214 | 160316 | I | 71 | NT | 2
12 | 1214 | 160314 | O | 71 | NT | 2
12 | 1214 | 160321 | I | 76 | NT | 2
12 | 1214 | 160313 | O | 76 | NT | 2
12 | 1214 | 160319 | I | 84 | NT | 2
12 | 1214 | 160311 | O | 84 | NT | 2
13 | 1217 | 160380 | I | 46 | NT | 2
13 | 1217 | 160383 | I | 46 | NT | 2
13 | 1217 | 160376 | O | 46 | NT | 2
13 | 1217 | 160381 | O | 46 | NT | 2
13 | 1217 | 160386 | I | 75 | NT | 2
13 | 1217 | 160390 | O | 75 | NT | 2
13 | 1218 | 160413 | I | 67 | NT | 2
13 | 1218 | 160403 | O | 67 | NT | 2
13 | 1218 | 160402 | I | 72 | NT | 2
13 | 1218 | 160411 | O | 72 | NT | 2
13 | 1218 | 160412 | I | 80 | NT | 2
13 | 1218 | 160408 | O | 80 | NT | 2
14 | 1216 | 160358 | I | 46 | NT | 2
14 | 1216 | 160359 | O | 46 | NT | 2
14 | 1216 | 160350 | I | 62 | NT | 2
14 | 1216 | 160355 | O | 62 | NT | 2
14 | 1216 | 160366 | I | 84 | NT | 2
14 | 1216 | 160368 | O | 84 | NT | 2
14 | 1221 | 160480 | I | 63 | NT | 2
14 | 1221 | 160482 | O | 63 | NT | 2
14 | 1221 | 160466 | I | 83 | NT | 2
14 | 1221 | 160473 | O | 83 | NT | 2
14 | 1221 | 160483 | I | 90 | NT | 2
14 | 1221 | 160476 | O | 90 | NT | 2
15 | 1201 | 160018 | I | 71 | NT | 2
15 | 1201 | 160008 | O | 71 | NT | 2
15 | 1201 | 160019 | I | 74 | NT | 2
15 | 1201 | 160015 | O | 74 | NT | 2
15 | 1201 | 160010 | I | 85 | NT | 2
15 | 1201 | 160005 | O | 85 | NT | 2
15 | 1207 | 160155 | I | 46 | NT | 2
15 | 1207 | 160161 | O | 46 | NT | 2
15 | 1207 | 160160 | I | 68 | NT | 2
15 | 1207 | 160151 | O | 68 | NT | 2
15 | 1207 | 160158 | I | 77 | NT | 2
15 | 1207 | 160159 | O | 77 | NT | 2
16 | 1206 | 160138 | I | 46 | NT | 2
16 | 1206 | 160137 | I | 46 | NT | 2
16 | 1206 | 160134 | O | 46 | NT | 2
16 | 1206 | 160132 | O | 46 | NT | 2
16 | 1206 | 160135 | I | 73 | NT | 2
16 | 1206 | 160130 | O | 73 | NT | 2
16 | 1224 | 160541 | I | 67 | NT | 2
16 | 1224 | 160543 | O | 67 | NT | 2
16 | 1224 | 160546 | I | 72 | NT | 2
16 | 1224 | 160550 | O | 72 | NT | 2
17 | 1212 | 160275 | I | 69 | NT | 2
17 | 1212 | 160272 | O | 69 | NT | 2
17 | 1212 | 160270 | I | 84 | NT | 2
17 | 1212 | 160276 | O | 84 | NT | 2
17 | 1212 | 160265 | I | 87 | NT | 2
17 | 1212 | 160268 | O | 87 | NT | 2
17 | 1223 | 160529 | I | 71 | NT | 2
17 | 1223 | 160528 | O | 71 | NT | 2
17 | 1223 | 160516 | I | 76 | NT | 2
17 | 1223 | 160523 | O | 76 | NT | 2
17 | 1223 | 160526 | I | 83 | NT | 2
17 | 1223 | 160519 | O | 83 | NT | 2
18 | 1208 | 160179 | I | 66 | NT | 2
18 | 1208 | 160174 | O | 66 | NT | 2
18 | 1208 | 160182 | I | 71 | NT | 2
18 | 1208 | 160173 | O | 71 | NT | 2
18 | 1213 | 160289 | I | 76 | NT | 2
18 | 1213 | 160293 | O | 76 | NT | 2
18 | 1213 | 160290 | I | 80 | NT | 2
18 | 1213 | 160287 | O | 80 | NT | 2
18 | 1213 | 160294 | I | 87 | NT | 2
18 | 1213 | 160288 | O | 87 | NT | 2
19 | 1211 | 160253 | I | 60 | NT | 2
19 | 1211 | 160252 | O | 60 | NT | 2
19 | 1211 | 160245 | I | 74 | NT | 2
19 | 1211 | 160242 | O | 74 | NT | 2
19 | 1211 | 160247 | I | 85 | NT | 2
19 | 1211 | 160243 | O | 85 | NT | 2
19 | 1220 | 160455 | I | 79 | NT | 2
19 | 1220 | 160448 | I | 79 | NT | 2
19 | 1220 | 160449 | O | 79 | NT | 2
19 | 1220 | 160451 | O | 79 | NT | 2
19 | 1220 | 160457 | I | 85 | NT | 2
19 | 1220 | 160458 | O | 85 | NT | 2
20 | 1204 | 160083 | I | 62 | NT | 2
20 | 1204 | 160084 | O | 62 | NT | 2
20 | 1204 | 160075 | I | 90 | NT | 2
20 | 1204 | 160086 | O | 90 | NT | 2
20 | 1204 | 160079 | I | 2 | ST | 2
20 | 1204 | 160077 | O | 2 | ST | 2
20 | 1205 | 160115 | I | 67 | NT | 2
20 | 1205 | 160112 | I | 67 | NT | 2
20 | 1205 | 160113 | O | 67 | NT | 2
20 | 1205 | 160111 | O | 67 | NT | 2
20 | 1205 | 160114 | I | 86 | NT | 2
20 | 1205 | 160108 | O | 86 | NT | 2
21 | 1219 | 160426 | I | 64 | NT | 2
21 | 1219 | 160431 | O | 64 | NT | 2
21 | 1219 | 160430 | I | 71 | NT | 2
21 | 1219 | 160428 | O | 71 | NT | 2
21 | 1219 | 160418 | I | 81 | NT | 2
21 | 1219 | 160421 | O | 81 | NT | 2
21 | 1222 | 160497 | I | 46 | NT | 2
21 | 1222 | 160495 | O | 46 | NT | 2
21 | 1222 | 160499 | I | 62 | NT | 2
21 | 1222 | 160498 | O | 62 | NT | 2
21 | 1222 | 160503 | I | 70 | NT | 2
21 | 1222 | 160501 | O | 70 | NT | 2
22 | 1203 | 160063 | I | 57 | NT | 2
22 | 1203 | 160060 | O | 57 | NT | 2
22 | 1203 | 160068 | I | 64 | NT | 2
22 | 1203 | 160058 | O | 64 | NT | 2
22 | 1203 | 160066 | I | 83 | NT | 2
22 | 1203 | 160067 | O | 83 | NT | 2
22 | 1215 | 160337 | I | 62 | NT | 2
22 | 1215 | 160336 | O | 62 | NT | 2
22 | 1215 | 160338 | I | 71 | NT | 2
22 | 1215 | 160335 | O | 71 | NT | 2
22 | 1215 | 160342 | I | 79 | NT | 2
22 | 1215 | 160343 | O | 79 | NT | 2
23 | 1209 | 160201 | I | 66 | NT | 2
23 | 1209 | 160205 | I | 66 | NT | 2
23 | 1209 | 160206 | O | 66 | NT | 2
23 | 1209 | 160200 | O | 66 | NT | 2
23 | 1209 | 160207 | I | 84 | NT | 2
23 | 1209 | 160191 | O | 84 | NT | 2
23 | 1210 | 160223 | I | 65 | NT | 2
23 | 1210 | 160222 | O | 65 | NT | 2
23 | 1210 | 160227 | I | 69 | NT | 2
23 | 1210 | 160226 | O | 69 | NT | 2
23 | 1210 | 160228 | I | 84 | NT | 2
23 | 1210 | 160230 | O | 84 | NT | 2
24 | 1202 | 160042 | I | 65 | NT | 2
24 | 1202 | 160034 | O | 65 | NT | 2
24 | 1202 | 160044 | I | 85 | NT | 2
24 | 1202 | 160041 | O | 85 | NT | 2
24 | 1202 | 160033 | I | 87 | NT | 2
24 | 1202 | 160038 | O | 87 | NT | 2
24 | 1214 | 160313 | I | 71 | NT | 2
24 | 1214 | 160321 | O | 71 | NT | 2
24 | 1214 | 160319 | I | 83 | NT | 2
24 | 1214 | 160311 | O | 83 | NT | 2
24 | 1214 | 160315 | I | 89 | NT | 2
24 | 1214 | 160320 | O | 89 | NT | 2
25 | 1201 | 160020 | I | 59 | NT | 2
25 | 1201 | 160023 | O | 59 | NT | 2
25 | 1201 | 160018 | I | 77 | NT | 2
25 | 1201 | 160016 | O | 77 | NT | 2
25 | 1201 | 160013 | I | 83 | NT | 2
25 | 1201 | 160012 | O | 83 | NT | 2
25 | 1216 | 160362 | I | 46 | NT | 2
25 | 1216 | 160361 | O | 46 | NT | 2
25 | 1216 | 160364 | I | 57 | NT | 2
25 | 1216 | 160365 | O | 57 | NT | 2
25 | 1216 | 160366 | I | 68 | NT | 2
25 | 1216 | 160360 | O | 68 | NT | 2
26 | 1207 | 160154 | I | 63 | NT | 2
26 | 1207 | 160151 | O | 63 | NT | 2
26 | 1207 | 160153 | I | 77 | NT | 2
26 | 1207 | 160160 | O | 77 | NT | 2
26 | 1221 | 160482 | I | 74 | NT | 2
26 | 1221 | 160480 | O | 74 | NT | 2
26 | 1221 | 160474 | I | 79 | NT | 2
26 | 1221 | 160476 | O | 79 | NT | 2
26 | 1221 | 160466 | I | 86 | NT | 2
26 | 1221 | 160481 | O | 86 | NT | 2
27 | 1217 | 160372 | I | 46 | NT | 2
27 | 1217 | 160373 | O | 46 | NT | 2
27 | 1217 | 160381 | I | 52 | NT | 2
27 | 1217 | 160386 | O | 52 | NT | 2
27 | 1217 | 160384 | I | 70 | NT | 2
27 | 1217 | 160391 | O | 70 | NT | 2
27 | 1224 | 160541 | I | 74 | NT | 2
27 | 1224 | 160540 | O | 74 | NT | 2
27 | 1224 | 160542 | I | 76 | NT | 2
27 | 1224 | 160543 | O | 76 | NT | 2
27 | 1224 | 160548 | I | 83 | NT | 2
27 | 1224 | 160547 | O | 83 | NT | 2
28 | 1206 | 160136 | I | 56 | NT | 2
28 | 1206 | 160133 | O | 56 | NT | 2
28 | 1206 | 160126 | I | 61 | NT | 2
28 | 1206 | 160130 | O | 61 | NT | 2
28 | 1206 | 160134 | I | 76 | NT | 2
28 | 1206 | 160137 | O | 76 | NT | 2
28 | 1218 | 160402 | I | 57 | NT | 2
28 | 1218 | 160403 | O | 57 | NT | 2
28 | 1218 | 160396 | I | 67 | NT | 2
28 | 1218 | 160409 | O | 67 | NT | 2
28 | 1218 | 160400 | I | 78 | NT | 2
28 | 1218 | 160411 | O | 78 | NT | 2
29 | 1213 | 160287 | I | 46 | NT | 2
29 | 1213 | 160296 | O | 46 | NT | 2
29 | 1213 | 160288 | I | 71 | NT | 2
29 | 1213 | 160290 | O | 71 | NT | 2
29 | 1213 | 160295 | I | 3 | ST | 2
29 | 1213 | 160298 | O | 3 | ST | 2
29 | 1223 | 160519 | I | 73 | NT | 2
29 | 1223 | 160526 | O | 73 | NT | 2
29 | 1223 | 160524 | I | 1 | ST | 2
29 | 1223 | 160529 | O | 1 | ST | 2
30 | 1208 | 160179 | I | 55 | NT | 2
30 | 1208 | 160174 | O | 55 | NT | 2
30 | 1208 | 160180 | I | 69 | NT | 2
30 | 1208 | 160175 | O | 69 | NT | 2
30 | 1208 | 160167 | I | 76 | NT | 2
30 | 1208 | 160165 | O | 76 | NT | 2
30 | 1212 | 160274 | I | 59 | NT | 2
30 | 1212 | 160276 | O | 59 | NT | 2
30 | 1212 | 160270 | I | 70 | NT | 2
30 | 1212 | 160272 | O | 70 | NT | 2
30 | 1212 | 160275 | I | 84 | NT | 2
30 | 1212 | 160268 | O | 84 | NT | 2
31 | 1205 | 160115 | I | 57 | NT | 2
31 | 1205 | 160107 | O | 57 | NT | 2
31 | 1205 | 160112 | I | 71 | NT | 2
31 | 1205 | 160104 | O | 71 | NT | 2
31 | 1205 | 160105 | I | 90 | NT | 2
31 | 1205 | 160108 | O | 90 | NT | 2
31 | 1222 | 160498 | I | 61 | NT | 2
31 | 1222 | 160502 | O | 61 | NT | 2
31 | 1222 | 160499 | I | 69 | NT | 2
31 | 1222 | 160506 | O | 69 | NT | 2
31 | 1222 | 160505 | I | 90 | NT | 2
31 | 1222 | 160504 | O | 90 | NT | 2
32 | 1204 | 160083 | I | 82 | NT | 2
32 | 1204 | 160087 | O | 82 | NT | 2
32 | 1204 | 160088 | I | 90 | NT | 2
32 | 1204 | 160092 | O | 90 | NT | 2
32 | 1204 | 160090 | I | 2 | ST | 2
32 | 1204 | 160085 | O | 2 | ST | 2
32 | 1219 | 160426 | I | 60 | NT | 2
32 | 1219 | 160436 | O | 60 | NT | 2
32 | 1219 | 160433 | I | 67 | NT | 2
32 | 1219 | 160435 | O | 67 | NT | 2
32 | 1219 | 160432 | I | 84 | NT | 2
32 | 1219 | 160428 | O | 84 | NT | 2
33 | 1202 | 160042 | I | 46 | NT | 2
33 | 1202 | 160045 | I | 46 | NT | 2
33 | 1202 | 160031 | O | 46 | NT | 2
33 | 1202 | 160038 | O | 46 | NT | 2
33 | 1202 | 160039 | I | 78 | NT | 2
33 | 1202 | 160041 | O | 78 | NT | 2
33 | 1210 | 160211 | I | 71 | NT | 2
33 | 1210 | 160226 | O | 71 | NT | 2
33 | 1210 | 160219 | I | 80 | NT | 2
33 | 1210 | 160230 | O | 80 | NT | 2
33 | 1210 | 160214 | I | 86 | NT | 2
33 | 1210 | 160229 | O | 86 | NT | 2
34 | 1209 | 160188 | I | 46 | NT | 2
34 | 1209 | 160203 | O | 46 | NT | 2
34 | 1209 | 160204 | I | 71 | NT | 2
34 | 1209 | 160207 | O | 71 | NT | 2
34 | 1209 | 160200 | I | 83 | NT | 2
34 | 1209 | 160198 | O | 83 | NT | 2
34 | 1214 | 160316 | I | 46 | NT | 2
34 | 1214 | 160314 | O | 46 | NT | 2
34 | 1214 | 160321 | I | 61 | NT | 2
34 | 1214 | 160311 | O | 61 | NT | 2
34 | 1214 | 160313 | I | 81 | NT | 2
34 | 1214 | 160320 | O | 81 | NT | 2
35 | 1211 | 160237 | I | 60 | NT | 2
35 | 1211 | 160240 | O | 60 | NT | 2
35 | 1211 | 160251 | I | 74 | NT | 2
35 | 1211 | 160250 | O | 74 | NT | 2
35 | 1211 | 160249 | I | 81 | NT | 2
35 | 1211 | 160238 | O | 81 | NT | 2
35 | 1215 | 160338 | I | 70 | NT | 2
35 | 1215 | 160344 | O | 70 | NT | 2
35 | 1215 | 160335 | I | 77 | NT | 2
35 | 1215 | 160336 | O | 77 | NT | 2
35 | 1215 | 160340 | I | 90 | NT | 2
35 | 1215 | 160343 | O | 90 | NT | 2
36 | 1203 | 160068 | I | 71 | NT | 2
36 | 1203 | 160058 | O | 71 | NT | 2
36 | 1203 | 160066 | I | 87 | NT | 2
36 | 1203 | 160067 | O | 87 | NT | 2
36 | 1203 | 160069 | I | 2 | ST | 2
36 | 1203 | 160062 | O | 2 | ST | 2
36 | 1220 | 160458 | I | 63 | NT | 2
36 | 1220 | 160457 | O | 63 | NT | 2
36 | 1220 | 160448 | I | 70 | NT | 2
36 | 1220 | 160454 | O | 70 | NT | 2
36 | 1220 | 160450 | I | 82 | NT | 2
36 | 1220 | 160451 | O | 82 | NT | 2
37 | 1213 | 160289 | I | 101 | ET | 1
37 | 1213 | 160293 | O | 101 | ET | 1
37 | 1213 | 160294 | I | 104 | ET | 1
37 | 1213 | 160288 | O | 104 | ET | 1
37 | 1221 | 160480 | I | 58 | NT | 2
37 | 1221 | 160473 | O | 58 | NT | 2
37 | 1221 | 160479 | I | 70 | NT | 2
37 | 1221 | 160481 | O | 70 | NT | 2
37 | 1221 | 160474 | I | 77 | NT | 2
37 | 1221 | 160472 | O | 77 | NT | 2
38 | 1212 | 160276 | I | 69 | NT | 2
38 | 1212 | 160272 | O | 69 | NT | 2
38 | 1212 | 160275 | I | 79 | NT | 2
38 | 1212 | 160271 | O | 79 | NT | 2
38 | 1212 | 160270 | I | 84 | NT | 2
38 | 1212 | 160262 | O | 84 | NT | 2
38 | 1224 | 160550 | I | 55 | NT | 2
38 | 1224 | 160551 | O | 55 | NT | 2
38 | 1224 | 160546 | I | 63 | NT | 2
38 | 1224 | 160543 | O | 63 | NT | 2
39 | 1204 | 160092 | I | 110 | ET | 2
39 | 1204 | 160086 | O | 110 | ET | 2
39 | 1204 | 160090 | I | 120 | ET | 2
39 | 1204 | 160073 | O | 120 | ET | 2
39 | 1204 | 160089 | I | 88 | NT | 2
39 | 1204 | 160091 | O | 88 | NT | 2
39 | 1214 | 160313 | I | 117 | ET | 2
39 | 1214 | 160310 | O | 117 | ET | 2
39 | 1214 | 160316 | I | 50 | NT | 2
39 | 1214 | 160311 | O | 50 | NT | 2
39 | 1214 | 160321 | I | 87 | NT | 2
39 | 1214 | 160313 | O | 87 | NT | 2
40 | 1207 | 160151 | I | 46 | NT | 2
40 | 1207 | 160152 | O | 46 | NT | 2
40 | 1207 | 160158 | I | 73 | NT | 2
40 | 1207 | 160159 | O | 73 | NT | 2
40 | 1207 | 160157 | I | 2 | ST | 2
40 | 1207 | 160151 | O | 2 | ST | 2
40 | 1215 | 160345 | I | 65 | NT | 2
40 | 1215 | 160344 | O | 65 | NT | 2
40 | 1215 | 160331 | I | 68 | NT | 2
40 | 1215 | 160337 | O | 68 | NT | 2
40 | 1215 | 160335 | I | 71 | NT | 2
40 | 1215 | 160336 | O | 71 | NT | 2
41 | 1208 | 160167 | I | 72 | NT | 2
41 | 1208 | 160184 | I | 72 | NT | 2
41 | 1208 | 160165 | O | 72 | NT | 2
41 | 1208 | 160173 | O | 72 | NT | 2
41 | 1208 | 160180 | I | 76 | NT | 2
41 | 1208 | 160175 | O | 76 | NT | 2
41 | 1218 | 160404 | I | 46 | NT | 2
41 | 1218 | 160411 | O | 46 | NT | 2
41 | 1218 | 160414 | I | 64 | NT | 2
41 | 1218 | 160412 | O | 64 | NT | 2
41 | 1218 | 160399 | I | 84 | NT | 2
41 | 1218 | 160396 | O | 84 | NT | 2
42 | 1203 | 160058 | I | 70 | NT | 2
42 | 1203 | 160068 | O | 70 | NT | 2
42 | 1203 | 160065 | I | 76 | NT | 2
42 | 1203 | 160067 | O | 76 | NT | 2
42 | 1203 | 160061 | I | 81 | NT | 2
42 | 1203 | 160062 | O | 81 | NT | 2
42 | 1209 | 160196 | I | 46 | NT | 2
42 | 1209 | 160203 | O | 46 | NT | 2
42 | 1209 | 160205 | I | 75 | NT | 2
42 | 1209 | 160195 | O | 75 | NT | 2
42 | 1209 | 160201 | I | 79 | NT | 2
42 | 1209 | 160191 | O | 79 | NT | 2
43 | 1211 | 160245 | I | 54 | NT | 2
43 | 1211 | 160242 | O | 54 | NT | 2
43 | 1211 | 160251 | I | 82 | NT | 2
43 | 1211 | 160248 | O | 82 | NT | 2
43 | 1211 | 160237 | I | 84 | NT | 2
43 | 1211 | 160243 | O | 84 | NT | 2
43 | 1219 | 160433 | I | 46 | NT | 2
43 | 1219 | 160436 | O | 46 | NT | 2
43 | 1219 | 160434 | I | 70 | NT | 2
43 | 1219 | 160435 | O | 70 | NT | 2
43 | 1219 | 160437 | I | 81 | NT | 2
43 | 1219 | 160433 | O | 81 | NT | 2
44 | 1206 | 160133 | I | 46 | NT | 2
44 | 1206 | 160128 | O | 46 | NT | 2
44 | 1206 | 160138 | I | 60 | NT | 2
44 | 1206 | 160132 | O | 60 | NT | 2
44 | 1206 | 160135 | I | 87 | NT | 2
44 | 1206 | 160136 | O | 87 | NT | 2
44 | 1210 | 160211 | I | 76 | NT | 2
44 | 1210 | 160230 | O | 76 | NT | 2
44 | 1210 | 160219 | I | 89 | NT | 2
44 | 1210 | 160226 | O | 89 | NT | 2
45 | 1213 | 160289 | I | 98 | ET | 1
45 | 1213 | 160293 | O | 98 | ET | 1
45 | 1213 | 160290 | I | 82 | NT | 2
45 | 1213 | 160288 | O | 82 | NT | 2
45 | 1214 | 160313 | I | 96 | ET | 1
45 | 1214 | 160318 | O | 96 | ET | 1
45 | 1214 | 160314 | I | 70 | NT | 2
45 | 1214 | 160310 | O | 70 | NT | 2
45 | 1214 | 160321 | I | 80 | NT | 2
45 | 1214 | 160313 | O | 80 | NT | 2
46 | 1203 | 160061 | I | 46 | NT | 2
46 | 1203 | 160058 | O | 46 | NT | 2
46 | 1203 | 160068 | I | 75 | NT | 2
46 | 1203 | 160054 | O | 75 | NT | 2
46 | 1203 | 160065 | I | 83 | NT | 2
46 | 1203 | 160067 | O | 83 | NT | 2
46 | 1224 | 160542 | I | 78 | NT | 2
46 | 1224 | 160543 | O | 78 | NT | 2
46 | 1224 | 160551 | I | 80 | NT | 2
46 | 1224 | 160550 | O | 80 | NT | 2
46 | 1224 | 160534 | I | 90 | NT | 2
46 | 1224 | 160544 | O | 90 | NT | 2
47 | 1208 | 160180 | I | 16 | NT | 1
47 | 1208 | 160175 | O | 16 | NT | 1
47 | 1208 | 160173 | I | 72 | NT | 2
47 | 1208 | 160182 | O | 72 | NT | 2
47 | 1211 | 160253 | I | 120 | ET | 2
47 | 1211 | 160236 | O | 120 | ET | 2
47 | 1211 | 160237 | I | 86 | NT | 2
47 | 1211 | 160243 | O | 86 | NT | 2
47 | 1211 | 160251 | I | 108 | NT | 2
47 | 1211 | 160248 | O | 108 | NT | 2
48 | 1207 | 160158 | I | 60 | NT | 2
48 | 1207 | 160159 | O | 60 | NT | 2
48 | 1207 | 160146 | I | 72 | NT | 2
48 | 1207 | 160145 | O | 72 | NT | 2
48 | 1207 | 160151 | I | 80 | NT | 2
48 | 1207 | 160154 | O | 80 | NT | 2
48 | 1210 | 160214 | I | 46 | NT | 2
48 | 1210 | 160227 | I | 46 | NT | 2
48 | 1210 | 160220 | O | 46 | NT | 2
48 | 1210 | 160226 | O | 46 | NT | 2
48 | 1210 | 160228 | I | 83 | NT | 2
48 | 1210 | 160230 | O | 83 | NT | 2
49 | 1214 | 160311 | I | 74 | NT | 2
49 | 1214 | 160316 | O | 74 | NT | 2
49 | 1214 | 160314 | I | 79 | NT | 2
49 | 1214 | 160310 | O | 79 | NT | 2
49 | 1214 | 160321 | I | 86 | NT | 2
49 | 1214 | 160320 | O | 86 | NT | 2
49 | 1224 | 160551 | I | 58 | NT | 2
49 | 1224 | 160543 | O | 58 | NT | 2
49 | 1224 | 160548 | I | 63 | NT | 2
49 | 1224 | 160550 | O | 63 | NT | 2
49 | 1224 | 160546 | I | 66 | NT | 2
49 | 1224 | 160534 | O | 66 | NT | 2
50 | 1207 | 160152 | I | 71 | NT | 2
50 | 1207 | 160154 | O | 71 | NT | 2
50 | 1207 | 160158 | I | 78 | NT | 2
50 | 1207 | 160159 | O | 78 | NT | 2
50 | 1207 | 160150 | I | 2 | ST | 2
50 | 1207 | 160160 | O | 2 | ST | 2
50 | 1208 | 160170 | I | 61 | NT | 2
50 | 1208 | 160165 | O | 61 | NT | 2
50 | 1208 | 160174 | I | 67 | NT | 2
50 | 1208 | 160172 | O | 67 | NT | 2
50 | 1208 | 160178 | I | 79 | NT | 2
50 | 1208 | 160180 | O | 79 | NT | 2
51 | 1207 | 160161 | I | 110 | ET | 2
51 | 1207 | 160154 | O | 110 | ET | 2
51 | 1207 | 160151 | I | 58 | NT | 2
51 | 1207 | 160154 | O | 58 | NT | 2
51 | 1207 | 160158 | I | 78 | NT | 2
51 | 1207 | 160159 | O | 78 | NT | 2
51 | 1214 | 160321 | I | 25 | NT | 1
51 | 1214 | 160322 | O | 25 | NT | 1
51 | 1214 | 160314 | I | 66 | NT | 2
51 | 1214 | 160310 | O | 66 | NT | 2
51 | 1214 | 160319 | I | 79 | NT | 2
51 | 1214 | 160316 | O | 79 | NT | 2
player_id | team_id | jersey_no | player_name | posi_to_play | dt_of_bir | age | playing_club
-----------+---------+-----------+-------------------------+--------------+------------+-----+---------------------
160001 | 1201 | 1 | Etrit Berisha | GK | 1989-03-10 | 27 | Lazio
160008 | 1201 | 2 | Andi Lila | DF | 1986-02-12 | 30 | Giannina
160016 | 1201 | 3 | Ermir Lenjani | MF | 1989-08-05 | 26 | Nantes
160007 | 1201 | 4 | Elseid Hysaj | DF | 1994-02-20 | 22 | Napoli
160013 | 1201 | 5 | Lorik Cana | MF | 1983-07-27 | 32 | Nantes
160010 | 1201 | 6 | Frederic Veseli | DF | 1992-11-20 | 23 | Lugano
160004 | 1201 | 7 | Ansi Agolli | DF | 1982-10-11 | 33 | Qarabag
160012 | 1201 | 8 | Migjen Basha | MF | 1987-01-05 | 29 | Como
160017 | 1201 | 9 | Ledian Memushaj | MF | 1986-12-17 | 29 | Pescara
160023 | 1201 | 10 | Armando Sadiku | FD | 1991-05-27 | 25 | Vaduz
160022 | 1201 | 11 | Shkelzen Gashi | FD | 1988-07-15 | 27 | Colorado
160003 | 1201 | 12 | Orges Shehi | GK | 1977-09-25 | 38 | Skenderbeu
160015 | 1201 | 13 | Burim Kukeli | MF | 1984-01-16 | 32 | Zurich
160019 | 1201 | 14 | Taulant Xhaka | MF | 1991-03-28 | 25 | Basel
160009 | 1201 | 15 | Mergim Mavraj | DF | 1986-06-09 | 30 | Koln
160021 | 1201 | 16 | Sokol Cikalleshi | FD | 1990-07-27 | 25 | Istanbul Basaksehir
160006 | 1201 | 17 | Naser Aliji | DF | 1993-12-27 | 22 | Basel
160005 | 1201 | 18 | Arlind Ajeti | DF | 1993-09-25 | 22 | Frosinone
160020 | 1201 | 19 | Bekim Balaj | FD | 1991-01-11 | 25 | Rijeka
160014 | 1201 | 20 | Ergys Kace | MF | 1993-07-08 | 22 | PAOK
160018 | 1201 | 21 | Odise Roshi | MF | 1991-05-22 | 25 | Rijeka
160011 | 1201 | 22 | Amir Abrashi | MF | 1990-03-27 | 26 | Freiburg
160002 | 1201 | 23 | Alban Hoxha | GK | 1987-11-23 | 28 | Partizani
160024 | 1202 | 1 | Robert Almer | GK | 1984-03-20 | 32 | Austria Wien
160036 | 1202 | 2 | Gyorgy Garics | MF | 1984-03-08 | 32 | Darmstadt
160027 | 1202 | 3 | Aleksandar Dragovic | DF | 1991-03-06 | 25 | Dynamo Kyiv
160029 | 1202 | 4 | Martin Hinteregger | DF | 1992-09-07 | 23 | Monchengladbach
160028 | 1202 | 5 | Christian Fuchs | DF | 1986-04-07 | 30 | Leicester
160038 | 1202 | 6 | Stefan Ilsanker | MF | 1989-05-18 | 27 | Leipzig
160043 | 1202 | 7 | Marko Arnautovic | FD | 1989-04-19 | 27 | Stoke
160034 | 1202 | 8 | David Alaba | MF | 1992-06-24 | 23 | Bayern
160046 | 1202 | 9 | Rubin Okotie | FD | 1987-06-06 | 29 | 1860 Munchen
160040 | 1202 | 10 | Zlatko Junuzovic | MF | 1987-09-26 | 28 | Bremen
160037 | 1202 | 11 | Martin Harnik | MF | 1987-06-10 | 29 | Stuttgart
160025 | 1202 | 12 | Heinz Lindner | GK | 1990-07-17 | 25 | Frankfurt
160032 | 1202 | 13 | Markus Suttner | DF | 1987-04-16 | 29 | Ingolstadt
160035 | 1202 | 14 | Julian Baumgartlinger | MF | 1988-01-02 | 28 | Mainz
160031 | 1202 | 15 | Sebastian Prodl | DF | 1987-06-21 | 28 | Watford
160033 | 1202 | 16 | Kevin Wimmer | DF | 1992-11-15 | 23 | Tottenham
160030 | 1202 | 17 | Florian Klein | DF | 1986-11-17 | 29 | Stuttgart
160042 | 1202 | 18 | Alessandro Schopf | MF | 1994-02-07 | 22 | Schalke
160044 | 1202 | 19 | Lukas Hinterseer | FD | 1991-03-28 | 25 | Ingolstadt
160041 | 1202 | 20 | Marcel Sabitzer | MF | 1994-03-17 | 22 | Leipzig
160045 | 1202 | 21 | Marc Janko | FD | 1983-06-25 | 32 | Basel
160039 | 1202 | 22 | Jakob Jantscher | MF | 1989-01-08 | 27 | Luzern
160026 | 1202 | 23 | Ramazan Ozcan | GK | 1984-06-28 | 31 | Ingolstadt
160047 | 1203 | 1 | Thibaut Courtois | GK | 1992-05-11 | 24 | Chelsea
160050 | 1203 | 2 | Toby Alderweireld | DF | 1989-03-02 | 27 | Tottenham
160056 | 1203 | 3 | Thomas Vermaelen | DF | 1985-11-14 | 30 | Barcelona
160063 | 1203 | 4 | Radja Nainggolan | MF | 1988-05-04 | 28 | Roma
160057 | 1203 | 5 | Jan Vertonghen | DF | 1987-04-24 | 29 | Tottenham
160064 | 1203 | 6 | Axel Witsel | MF | 1989-01-12 | 27 | Zenit
160059 | 1203 | 7 | Kevin De Bruyne | MF | 1991-06-28 | 24 | Man. City
160061 | 1203 | 8 | Marouane Fellaini | MF | 1987-11-22 | 28 | Man. United
160067 | 1203 | 9 | Romelu Lukaku | FD | 1993-05-13 | 23 | Everton
160062 | 1203 | 10 | Eden Hazard | MF | 1991-01-07 | 25 | Chelsea
160058 | 1203 | 11 | Yannick Carrasco | MF | 1993-09-04 | 22 | Atletico
160049 | 1203 | 12 | Simon Mignolet | GK | 1988-08-06 | 27 | Liverpool
160048 | 1203 | 13 | Jean-Francois Gillet | GK | 1979-05-31 | 37 | Mechelen
160068 | 1203 | 14 | Dries Mertens | FD | 1987-05-06 | 29 | Napoli
160052 | 1203 | 15 | Jason Denayer | DF | 1995-06-28 | 20 | Galatasaray
160055 | 1203 | 16 | Thomas Meunier | DF | 1991-09-12 | 24 | Club Brugge
160069 | 1203 | 17 | Divock Origi | FD | 1995-04-18 | 21 | Liverpool
160053 | 1203 | 18 | Christian Kabasele | DF | 1991-02-24 | 25 | Genk
160060 | 1203 | 19 | Mousa Dembele | MF | 1987-07-16 | 28 | Tottenham
160066 | 1203 | 20 | Christian Benteke | FD | 1990-12-03 | 25 | Liverpool
160054 | 1203 | 21 | Jordan Lukaku | DF | 1994-07-25 | 21 | Oostende
160065 | 1203 | 22 | Michy Batshuayi | FD | 1993-10-02 | 22 | Marseille
160051 | 1203 | 23 | Laurent Ciman | DF | 1985-08-05 | 30 | Montreal
160072 | 1204 | 1 | Ivan Vargic | GK | 1987-03-15 | 29 | Rijeka
160079 | 1204 | 2 | Sime Vrsaljko | DF | 1992-01-10 | 24 | Sassuolo
160077 | 1204 | 3 | Ivan Strinic | DF | 1987-07-17 | 28 | Napoli
160085 | 1204 | 4 | Ivan PeriSic | MF | 1989-02-02 | 27 | Internazionale
160073 | 1204 | 5 | Vedran Corluka | DF | 1986-02-05 | 30 | Lokomotiv Moskva
160074 | 1204 | 6 | Tin Jedvaj | DF | 1995-11-28 | 20 | Leverkusen
160086 | 1204 | 7 | Ivan Rakitic | MF | 1988-03-10 | 28 | Barcelona
160083 | 1204 | 8 | Mateo Kovacic | MF | 1994-05-06 | 22 | Real Madrid
160090 | 1204 | 9 | Andrej Kramaric | FD | 1991-06-19 | 24 | Hoffenheim
160084 | 1204 | 10 | Luka Modric | MF | 1985-09-09 | 30 | Real Madrid
160076 | 1204 | 11 | Darijo Srna | DF | 1982-05-01 | 34 | Shakhtar Donetsk
160070 | 1204 | 12 | Lovre Kalinic | GK | 1990-04-03 | 26 | Hajduk Split
160075 | 1204 | 13 | Gordon Schildenfeld | DF | 1985-03-18 | 31 | Dinamo Zagreb
160081 | 1204 | 14 | Marcelo Brozovic | MF | 1992-11-16 | 23 | Internazionale
160087 | 1204 | 15 | Marko Rog | MF | 1995-07-19 | 20 | Dinamo Zagreb
160089 | 1204 | 16 | Nikola Kalinic | FD | 1988-01-05 | 28 | Fiorentina
160091 | 1204 | 17 | Mario Mandzukic | FD | 1986-05-21 | 30 | Juventus
160082 | 1204 | 18 | Ante Coric | MF | 1997-04-14 | 19 | Dinamo Zagreb
160080 | 1204 | 19 | Milan Badelj | MF | 1989-02-25 | 27 | Fiorentina
160092 | 1204 | 20 | Marko Pjaca | FD | 1995-05-06 | 21 | Dinamo Zagreb
160078 | 1204 | 21 | Domagoj Vida | DF | 1989-04-29 | 27 | Dynamo Kyiv
160088 | 1204 | 22 | Duje Cop | FD | 1990-02-01 | 26 | Malaga
160071 | 1204 | 23 | Danijel SubaSic | GK | 1984-10-27 | 31 | Monaco
160093 | 1205 | 1 | Petr Cech | GK | 1982-05-20 | 34 | Arsenal
160098 | 1205 | 2 | Pavel Kaderabek | DF | 1992-04-25 | 24 | Hoffenheim
160099 | 1205 | 3 | Michal Kadlec | DF | 1984-12-13 | 31 | Fenerbahce
160096 | 1205 | 4 | Theodor Gebre Selassie | DF | 1986-12-24 | 29 | Bremen
160097 | 1205 | 5 | Roman Hubnik | DF | 1984-06-06 | 32 | Plzen
160101 | 1205 | 6 | TomasSivok | DF | 1983-09-15 | 32 | Bursaspor
160114 | 1205 | 7 | TomasNecid | FD | 1989-08-13 | 26 | Bursaspor
160100 | 1205 | 8 | David Limbersky | DF | 1983-10-06 | 32 | Plzen
160104 | 1205 | 9 | Borek Dockal | MF | 1988-09-30 | 27 | Sparta Praha
160110 | 1205 | 10 | TomasRosicky | MF | 1980-10-04 | 35 | Arsenal
160109 | 1205 | 11 | Daniel Pudil | MF | 1985-09-27 | 30 | Sheff. Wednesday
160115 | 1205 | 12 | Milan Skoda | FD | 1986-01-16 | 30 | Slavia Praha
160108 | 1205 | 13 | Jaroslav PlaSil | MF | 1982-01-05 | 34 | Bordeaux
160105 | 1205 | 14 | Daniel Kolar | MF | 1985-10-27 | 30 | Plzen
160107 | 1205 | 15 | David Pavelka | MF | 1991-05-18 | 25 | Kasimpasa
160095 | 1205 | 16 | TomasVaclik | GK | 1989-03-29 | 27 | Basel
160102 | 1205 | 17 | Marek Suchy | DF | 1988-03-29 | 28 | Basel
160112 | 1205 | 18 | Josef Sural | MF | 1990-05-30 | 26 | Sparta Praha
160106 | 1205 | 19 | Ladislav Krejci | MF | 1992-07-05 | 23 | Sparta Praha
160111 | 1205 | 20 | Jiri Skalak | MF | 1992-03-12 | 24 | Brighton
160113 | 1205 | 21 | David Lafata | FD | 1981-09-18 | 34 | Sparta Praha
160103 | 1205 | 22 | Vladimir Darida | MF | 1990-08-08 | 25 | Hertha
160094 | 1205 | 23 | TomasKoubek | GK | 1992-08-26 | 23 | Liberec
160117 | 1206 | 1 | Joe Hart | GK | 1987-04-19 | 29 | Man. City
160125 | 1206 | 2 | Kyle Walker | DF | 1990-05-28 | 26 | Tottenham
160122 | 1206 | 3 | Danny Rose | DF | 1990-07-02 | 25 | Tottenham
160131 | 1206 | 4 | James Milner | MF | 1986-01-04 | 30 | Liverpool
160120 | 1206 | 5 | Gary Cahill | DF | 1985-12-19 | 30 | Chelsea
160123 | 1206 | 6 | Chris Smalling | DF | 1989-11-22 | 26 | Man. United
160132 | 1206 | 7 | Raheem Sterling | MF | 1994-12-08 | 21 | Man. City
160130 | 1206 | 8 | Adam Lallana | MF | 1988-05-10 | 28 | Liverpool
160134 | 1206 | 9 | Harry Kane | FD | 1993-07-28 | 22 | Tottenham
160136 | 1206 | 10 | Wayne Rooney | FD | 1985-10-24 | 30 | Man. United
160138 | 1206 | 11 | Jamie Vardy | FD | 1987-01-11 | 29 | Leicester
160121 | 1206 | 12 | Nathaniel Clyne | DF | 1991-04-05 | 25 | Liverpool
160116 | 1206 | 13 | Fraser Forster | GK | 1988-03-17 | 28 | Southampton
160129 | 1206 | 14 | Jordan Henderson | MF | 1990-06-17 | 26 | Liverpool
160137 | 1206 | 15 | Daniel Sturridge | FD | 1989-09-01 | 26 | Liverpool
160124 | 1206 | 16 | John Stones | DF | 1994-05-28 | 22 | Everton
160128 | 1206 | 17 | Eric Dier | MF | 1994-01-15 | 22 | Tottenham
160133 | 1206 | 18 | Jack Wilshere | MF | 1992-01-01 | 24 | Arsenal
160127 | 1206 | 19 | Ross Barkley | MF | 1993-12-05 | 22 | Everton
160126 | 1206 | 20 | Dele Alli | MF | 1996-04-11 | 20 | Tottenham
160119 | 1206 | 21 | Ryan Bertrand | DF | 1989-08-05 | 26 | Southampton
160135 | 1206 | 22 | Marcus Rashford | FD | 1997-10-31 | 18 | Man. United
160118 | 1206 | 23 | Tom Heaton | GK | 1986-04-15 | 30 | Burnley
160140 | 1207 | 1 | Hugo Lloris | GK | 1986-12-26 | 29 | Tottenham
160144 | 1207 | 2 | Christophe Jallet | DF | 1983-10-31 | 32 | Lyon
160143 | 1207 | 3 | Patrice Evra | DF | 1981-05-15 | 35 | Juventus
160147 | 1207 | 4 | Adil Rami | DF | 1985-12-27 | 30 | Sevilla
160152 | 1207 | 5 | NGolo Kante | MF | 1991-03-29 | 25 | Leicester
160150 | 1207 | 6 | Yohan Cabaye | MF | 1986-01-14 | 30 | Crystal Palace
160160 | 1207 | 7 | Antoine Griezmann | FD | 1991-03-21 | 25 | Atletico
160154 | 1207 | 8 | Dimitri Payet | MF | 1987-03-29 | 29 | West Ham
160159 | 1207 | 9 | Olivier Giroud | FD | 1986-09-30 | 29 | Arsenal
160158 | 1207 | 10 | Andre-Pierre Gignac | FD | 1985-12-05 | 30 | Tigres
160161 | 1207 | 11 | Anthony Martial | FD | 1

Sql programming
Sample Output:
match_no | country_name | player_name | jersey_no | time_in_out ----------+--------------+------------------+-----------+------------- 39 | Croatia | Andrej Kramaric | 9 | 120 47 | Italy | Simone Zaza | 7 | 120 (2 rows)need an explanation for this answer? contact us directly to get an explanation for this answer