record athlete nation venue date #
record
athlete
nation
venue
date
#
first second first_number second_number
address
number parsed year month day
number
unitnum(unitnum) text text address date number
4.05 m (13 ft 31⁄4 in) sun caiyun china nanjing, china 21 may 1992 1
what is the difference between the number of times the record has been set by the czech republic and the number of times the record has been set by china ?
WP VBD-AUX DT NN IN DT NN IN NNS DT NN VBD-AUX VBD-AUX VBN IN DT NNP NNP CC DT NN IN NNS DT NN VBD-AUX VBD-AUX VBN IN NNP .
7
Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Keyword Column Keyword Literal.String Keyword Keyword
select abs ( ( select count ( * ) from w where c3 = 'czech republic' ) - ( select count ( * ) from w where c3 = 'china' ) )
None None None Keyword Keyword None Keyword Keyword Keyword None None None None None None None Literal Literal Keyword None Keyword Keyword Keyword None None None None None None Literal None
['diff', ''] ['diff', ''] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count'] ['diff', ''] ['agg', 'agg_count'] ['agg', 'agg_count'] ['agg', 'agg_count']