game day date kickoff opponent results
score results
record location attendance
game
day
date
kickoff
opponent
results score
results record
location
attendance
number
parsed year month day
number parsed year month day
number hour min
raw home
first second first_result first_number first_number1 first_number2
number number1 number2
number
number date date time text score(score) score text number
1 saturday november 9 7:05pm at detroit waza w 8-7 (ot) 1-0 melvindale civic center 545
how many times did the team play at home but did not win ?
WRB JJ NNS VBD-AUX DT NN NN IN NN CC VBD-AUX RB VB .
5
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.String
select count ( * ) from w where c5_home = 'home' and c6_first_result != 'w'
Keyword Keyword Keyword None None None None None Column None None Keyword Column None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c5_home ['comp', 'comp_not'] c6_first_result