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
select count ( * ) from w where c2_number1 = 1