year competition venue position notes
year
competition
venue
position
notes
number
address
first second first_number
first second first_number second_result
number text address rank(text) unitnum(score)
1996 world junior championships sydney, australia 15th (q) 7.91 m (w)
what is the difference between the number of times the position of third was achieved and the number of times the position of first was achieved ?
WP VBD-AUX DT NN IN DT NN IN NNS DT NN IN JJ VBD-AUX VBN CC DT NN IN NNS DT NN IN JJ VBD-AUX VBN .
1
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.Number Keyword Keyword
select abs ( ( select count ( * ) from w where c4_first_number = 3 ) - ( select count ( * ) from w where c4_first_number = 1 ) )
None None None Keyword Keyword None Keyword Keyword Keyword None Column None Literal None None Keyword None Keyword Keyword Keyword None Column None Literal None None None
['diff', ''] ['diff', ''] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c4_first_number ['diff', ''] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] c4_first_number