goal date venue opponent score result competition
goal
date
venue
opponent
score
result
competition
number
number parsed year month day
address
number number1 number2
number number1 number2
number date address text score score text
1 8 october 2010 ferenc puskas, budapest, hungary san marino 2-0 8-0 euro 2012 qualifying
how many games did he score but his team lost ?
WRB JJ NNS VBD-AUX PRP NN CC PRP$ NN VBN .
1
select count ( * ) from w where c6_number1 < c6_number2