# date venue opponent score result competition
#
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
number number1 number2
number date address text score score text
1 30 may 1928 olympic stadium (amsterdam), amsterdam, netherland mexico 1-0 7-1 1928 summer olympics
according to this table , did mexico or italy have more ` friendly ' competitions against spain ?
VBG TO DT NN , VBD-AUX NNP CC NNP VBD-AUX RBR `` JJ '' NNS IN NNP .
Italy
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Literal.String Keyword Literal.String Keyword Keyword Column Keyword Literal.String Keyword Keyword Column Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword
select c4 from w where c4 in ( 'mexico' , 'italy' ) and c7 = 'friendly' group by c4 order by count ( * ) desc limit 1
None None None None None None Literal Keyword Literal None Keyword None Literal None None Column None None
['conj', 'conj_or'] ['sort', 'sort_desc_group_count'] c4