date competition home team score away team score
date
competition
home team
score
away team
score
number parsed year month day
number
number
date text text number text number
16 october 2004 powergen cup bedford 26 tabard 13
how many games did bedford lose this season ?
WRB JJ NNS VBD-AUX NNP VB DT NN .
2
select ( select count ( c2 ) from w where c3 = 'bedford' and c4_number < c6_number ) + ( select count ( c2 ) from w where c5 = 'bedford' and c6_number < c4_number )