-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathInsertIntoMatchStats.sql
More file actions
93 lines (88 loc) · 11.3 KB
/
InsertIntoMatchStats.sql
File metadata and controls
93 lines (88 loc) · 11.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (145, 6, 1, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (124, 6, 1, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (8, 6, 1, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (399, 18, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (389, 18, 2, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (380, 18, 2, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (385, 18, 2, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (39, 18, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (32, 18, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (41, 18, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (33, 18, 2, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (211, 9, 5, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (203, 9, 5, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (199, 9, 5, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (119, 9, 5, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (117, 9, 5, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (111, 9, 5, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (348, 16, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (355, 16, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (322, 16, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (244, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (246, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (257, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (245, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (188, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (187, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (191, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (183, 11, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (317, 14, 12, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (78, 19, 4, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (87, 19, 4, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (377, 17, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (362, 17, 13, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (293, 17, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (294, 17, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (51, 3, 7, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (65, 3, 7, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (171, 3, 7, 1, 0, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (81, 8, 4, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (274, 12, 11, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (257, 12, 11, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (39, 2, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (293, 2, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (390, 18, 9, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (171, 7, 6, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (141, 7, 6, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (117, 16, 5, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (63, 20, 3, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (4, 1, 17, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (10, 1, 17, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (12, 1, 17, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (21, 1, 17, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (377, 1, 17, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (374, 1, 17, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (86, 4, 18, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (396, 4, 18, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (143, 6, 5, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (141, 6, 5, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (230, 10, 1, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (18, 10, 1, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (171, 7, 14, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (317, 7, 14, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (273, 12, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (270, 12, 13, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (377, 17, 20, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (376, 17, 20, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (445, 17, 20, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (207, 9, 16, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (64, 3, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (63, 3, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (57, 3, 15, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (323, 3, 15, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (189, 19, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (183, 19, 8, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (257, 11, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (246, 11, 2, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (40, 11, 2, 1, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (39, 2, 12, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (34, 2, 12, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (270, 2, 12, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (257, 20, 11, 0, 3, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (117, 5, 3, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (105, 5, 3, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (20, 1, 9, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (1, 1, 9, 0, 2, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (8, 1, 9, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (211, 1, 9, 0, 1, 0);
INSERT INTO MatchStats (PlayerID, HomeSportsTeamID, AwaySportsTeamID, NumCards, NumGoals, NumAssists) VALUES (213, 1, 9, 0, 2, 0);