week date opponent home/away result bye
week
date
opponent
home/away
result
bye
number
number parsed year month day
result number number1 number2
number date text text score text
1 february 8 new orleans voodoo home l 42-34 0
what is the total number of games lost during the month of april ?
WP VBD-AUX DT JJ NN IN NNS VBN IN DT NN IN NNP .
1
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Column Keyword Literal.Number
select count ( * ) from w where c5_result = 'l' and c2_month = 4
None None Keyword Keyword Keyword Keyword None Column Column Column Column Column Literal None
['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c5_result c2_month c2_month c2_month c2_month