-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathInsertIntoMatchs.sql
More file actions
87 lines (78 loc) · 6.68 KB
/
Copy pathInsertIntoMatchs.sql
File metadata and controls
87 lines (78 loc) · 6.68 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
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (6, 1, 5, 1, 1, 0, DATE "2019-08-16");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (18, 2, 4, 11, 1, 3, DATE "2019-08-17");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (9, 5, 5, 3, 1, 1, DATE "2019-08-17");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (16, 15, 3, 4, 2, 1, DATE "2019-08-17");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (20, 10, 1, 2, 0, 1, DATE "2019-08-17");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (11, 8, 6, 8, 4, 4, DATE "2019-08-17");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (14, 12, 4, 5, 1, 0, DATE "2019-08-18");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (19, 4, 2, 4, 0, 2, DATE "2019-08-18");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (17, 13, 5, 3, 1, 2, DATE "2019-08-18");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (3, 7, 3, 0, 1, 0, DATE "2019-08-18");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (8, 4, 2, 5, 0, 1, DATE "2019-08-23");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (12,11, 4, 7, 2, 1, DATE "2019-08-23");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (10, 15, 2, 2, 0, 0, DATE "2019-08-24");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (2, 13, 5, 2, 1, 1, DATE "2019-08-24");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (18, 9, 6, 2, 1, 0, DATE "2019-08-24");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (7, 6, 2, 2, 1, 1, DATE "2019-08-24");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (14, 19, 2, 1, 0, 0, DATE "2019-08-25");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (16, 5, 5, 3, 0, 1, DATE "2019-08-25");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (20, 3, 4, 3, 0, 1, DATE "2019-08-25");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (1, 17, 7, 4, 5, 2, DATE "2019-08-25");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (4, 18, 7, 1, 1, 1, DATE "2019-08-30");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (6, 5, 5, 2, 2, 0, DATE "2019-08-30");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (10, 1, 5, 4, 2, 2, DATE "2019-08-31");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (7, 14, 1, 1, 1, 1, DATE "2019-08-31");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (12, 13, 2, 4, 2, 0, DATE "2019-08-31");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (17, 20, 5, 5, 2, 1, DATE "2019-08-31");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (9, 16, 3, 1, 2, 0, DATE "2019-09-01");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (3, 15, 3, 2, 3, 2, DATE "2019-09-01");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (19, 8, 3, 5, 0, 3, DATE "2019-09-01");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (11, 2, 3, 5, 2, 2, DATE "2019-09-01");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (16, 6, 1, 2, 0, 0, DATE "2019-09-13");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (2, 12, 10, 3, 3, 2, DATE "2019-09-14");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (20, 11, 3, 3, 3, 3, DATE "2019-09-14");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (5, 3, 4, 2, 2, 0, DATE "2019-09-14");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, ShotsOnGoalHome, ShotsOnGoalAway, FinalScoreHome, FinalScoreAway, DateOfMatch)
VALUES (1, 9, 10, 4, 5, 2, DATE "2019-09-14");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, DateOfMatch)
VALUES (18, 13, DATE "2019-11-29");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, DateOfMatch)
VALUES (14, 2, DATE "2019-11-30");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, DateOfMatch)
VALUES (5, 15, DATE "2019-11-30");
INSERT INTO Matchs (HomeSportsTeamID, AwaySportsTeamID, DateOfMatch)
VALUES (16, 17, DATE "2019-11-30");