-
Notifications
You must be signed in to change notification settings - Fork 5
Expand file tree
/
Copy pathgoal.sql
More file actions
78 lines (77 loc) · 4.81 KB
/
goal.sql
File metadata and controls
78 lines (77 loc) · 4.81 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 goal VALUES ('1001','POL',"Robert Lewandowski",17.0);
INSERT INTO goal VALUES ('1001','GRE',"Dimitris Salpingidis",51.0);
INSERT INTO goal VALUES ('1002','RUS',"Alan Dzagoev",15.0);
INSERT INTO goal VALUES ('1002','RUS',"Alan Dzagoev",79.0);
INSERT INTO goal VALUES ('1002','RUS',"Roman Shirokov",24.0);
INSERT INTO goal VALUES ('1002','RUS',"Roman Pavlyuchenko",82.0);
INSERT INTO goal VALUES ('1002','CZE',"Václav Pilar",52.0);
CREATE TABLE goal ( matchid int(11) NOT NULL, teamid varchar(3) NULL, player varchar(100) NULL, gtime int(100) NOT NULL, PRIMARY KEY(matchid, gtime));
INSERT INTO goal VALUES ('1003','GRE',"Theofanis Gekas",53.0);
INSERT INTO goal VALUES ('1003','CZE',"Petr Jirácek",3.0);
INSERT INTO goal VALUES ('1003','CZE',"Václav Pilar",6.0);
INSERT INTO goal VALUES ('1004','POL',"Jakub Blaszczykowski",57.0);
INSERT INTO goal VALUES ('1004','RUS',"Alan Dzagoev",37.0);
INSERT INTO goal VALUES ('1005','CZE',"Petr Jirácek",72.0);
INSERT INTO goal VALUES ('1006','GRE',"Giorgos Karagounis",45.0);
INSERT INTO goal VALUES ('1007','DEN',"Michael Krohn-Dehli",24.0);
INSERT INTO goal VALUES ('1008','GER',"Mario Gómez",72.0);
INSERT INTO goal VALUES ('1009','DEN',"Nicklas Bendtner",41.0);
INSERT INTO goal VALUES ('1009','DEN',"Nicklas Bendtner",80.0);
INSERT INTO goal VALUES ('1009','POR',"Pepe (footballer born 1983)",24.0);
INSERT INTO goal VALUES ('1009','POR',"Hélder Postiga",36.0);
INSERT INTO goal VALUES ('1009','POR',"Silvestre Varela",87.0);
INSERT INTO goal VALUES ('1010','NED',"Robin van Persie",73.0);
INSERT INTO goal VALUES ('1010','GER',"Mario Gómez",24.0);
INSERT INTO goal VALUES ('1010','GER',"Mario Gómez",38.0);
INSERT INTO goal VALUES ('1011','POR',"Cristiano Ronaldo",28.0);
INSERT INTO goal VALUES ('1011','POR',"Cristiano Ronaldo",74.0);
INSERT INTO goal VALUES ('1011','NED',"Rafael van der Vaart",11.0);
INSERT INTO goal VALUES ('1012','DEN',"Michael Krohn-Dehli",24.0);
INSERT INTO goal VALUES ('1012','GER',"Lukas Podolski",19.0);
INSERT INTO goal VALUES ('1012','GER',"Lars Bender",80.0);
INSERT INTO goal VALUES ('1013','ESP',"Cesc Fàbregas",64.0);
INSERT INTO goal VALUES ('1013','ITA',"Antonio Di Natale",61.0);
INSERT INTO goal VALUES ('1014','IRL',"Sean St Ledger",19.0);
INSERT INTO goal VALUES ('1014','CRO',"Mario Mandžukic",3.0);
INSERT INTO goal VALUES ('1014','CRO',"Mario Mandžukic",49.0);
INSERT INTO goal VALUES ('1014','CRO',"Nikica Jelavic",43.0);
INSERT INTO goal VALUES ('1015','ITA',"Andrea Pirlo",39.0);
INSERT INTO goal VALUES ('1015','CRO',"Mario Mandžukic",72.0);
INSERT INTO goal VALUES ('1016','ESP',"Fernando Torres",4.0);
INSERT INTO goal VALUES ('1016','ESP',"Fernando Torres",70.0);
INSERT INTO goal VALUES ('1016','ESP',"David Silva",49.0);
INSERT INTO goal VALUES ('1016','ESP',"Cesc Fàbregas",83.0);
INSERT INTO goal VALUES ('1017','ESP',"Jesús Navas",88.0);
INSERT INTO goal VALUES ('1018','ITA',"Antonio Cassano",35.0);
INSERT INTO goal VALUES ('1018','ITA',"Mario Balotelli",90.0);
INSERT INTO goal VALUES ('1019','FRA',"Samir Nasri",39.0);
INSERT INTO goal VALUES ('1019','ENG',"Joleon Lescott",30.0);
INSERT INTO goal VALUES ('1020','UKR',"Andriy Shevchenko",55.0);
INSERT INTO goal VALUES ('1020','UKR',"Andriy Shevchenko",62.0);
INSERT INTO goal VALUES ('1020','SWE',"Zlatan Ibrahimovic",52.0);
INSERT INTO goal VALUES ('1021','FRA',"Jérémy Ménez",53.0);
INSERT INTO goal VALUES ('1021','FRA',"Yohan Cabaye",56.0);
INSERT INTO goal VALUES ('1022','SWE',"Glen Johnson (English footballer)",49.0);
INSERT INTO goal VALUES ('1022','SWE',"Olof Mellberg",59.0);
INSERT INTO goal VALUES ('1022','ENG',"Andy Carroll",23.0);
INSERT INTO goal VALUES ('1022','ENG',"Theo Walcott",64.0);
INSERT INTO goal VALUES ('1022','ENG',"Danny Welbeck",78.0);
INSERT INTO goal VALUES ('1023','ENG',"Wayne Rooney",48.0);
INSERT INTO goal VALUES ('1024','SWE',"Zlatan Ibrahimovic",54.0);
INSERT INTO goal VALUES ('1024','SWE',"Sebastian Larsson",90.0);
INSERT INTO goal VALUES ('1025','POR',"Cristiano Ronaldo",79.0);
INSERT INTO goal VALUES ('1026','GER',"Philipp Lahm",39.0);
INSERT INTO goal VALUES ('1026','GER',"Sami Khedira",61.0);
INSERT INTO goal VALUES ('1026','GER',"Miroslav Klose",68.0);
INSERT INTO goal VALUES ('1026','GER',"Marco Reus",74.0);
INSERT INTO goal VALUES ('1026','GRE',"Georgios Samaras",55.0);
INSERT INTO goal VALUES ('1026','GRE',"Dimitris Salpingidis",89.0);
INSERT INTO goal VALUES ('1027','ESP',"Xabi Alonso",19.0);
INSERT INTO goal VALUES ('1027','ESP',"Xabi Alonso",90.0);
INSERT INTO goal VALUES ('1030','GER',"Mesut Özil",90.0);
INSERT INTO goal VALUES ('1030','ITA',"Mario Balotelli",20.0);
INSERT INTO goal VALUES ('1030','ITA',"Mario Balotelli",36.0);
INSERT INTO goal VALUES ('1031','ESP',"David Silva",14.0);
INSERT INTO goal VALUES ('1031','ESP',"Jordi Alba",41.0);
INSERT INTO goal VALUES ('1031','ESP',"Fernando Torres",84.0);
INSERT INTO goal VALUES ('1031','ESP',"Juan Mata",nan);