home team score away team date agg
home team
score
away team
date
agg
number number1 number2
number parsed year month day
number number1 number2
text score text date score
aberdeen 7-1 hamilton academical 11-10-1978 8-1
which team scored higher as the home team , ayr united or morton ?
WDT NN VBD JJR IN DT NN NN , NNP NNP CC NNP .
Morton
Keyword Column Keyword Keyword Keyword Column Keyword Keyword Literal.String Keyword Literal.String Keyword Keyword Keyword Column Keyword Keyword Keyword
select c1 from w where c1 in ( 'ayr united' , 'morton' ) order by c2_number1 desc limit 1
None None Column Keyword None None Column Column None Literal Literal Keyword Literal None
c2_number1 ['sort', 'sort_desc'] c1 c1 ['conj', 'conj_or']