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
how many times did the home team have a score of only one against the away team ?
WRB JJ NNS VBD-AUX DT NN NN VBD-AUX DT NN IN RB CD IN DT RB NN .
4
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number
select count ( * ) from w where c2_number1 = 1
Keyword Keyword Keyword None None Column Column None None Column None None Literal None None None None None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c2_number1 c2_number1 c2_number1