date opponent venue result
date
opponent
venue
result
number parsed year month day
number number1 number2
date text text score
28 aug burnley a 3 - 4
how many goals did cardiff city f.c. score in the month of april ?
WRB JJ NNS VBD-AUX NNP NNP NNP NN IN DT NN IN NNP .
12
select sum ( c4_number1 ) from w where c1_month = 4