2008 manx grand prix
only two drivers in the 2008 manx grand prix drove at an average speed of higher than 100 mph .
{'scope': 'all', 'criterion': 'greater_than', 'value': '100', 'result': '2', 'col': '4', 'subset': None}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'speed', '100'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose speed record is greater than 100 .', 'tostr': 'filter_greater { all_rows ; speed ; 100 }'}], 'result': '2', 'ind': 1, 'tostr': 'count { filter_greater { all_rows ; speed ; 100 } }', 'tointer': 'select the rows whose speed record is greater than 100 . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 2, 'tostr': 'eq { count { filter_greater { all_rows ; speed ; 100 } } ; 2 } = true', 'tointer': 'select the rows whose speed record is greater than 100 . the number of such rows is 2 .'}
eq { count { filter_greater { all_rows ; speed ; 100 } } ; 2 } = true
select the rows whose speed record is greater than 100 . the number of such rows is 2 .
{'eq_2': 'eq', 'result_3': 'true', 'count_1': 'count', 'filter_greater_0': 'filter_greater', 'all_rows_4': 'all_rows', 'speed_5': 'speed', '100_6': '100', '2_7': '2'}
['rank', 'rider', 'team', 'speed', 'time']
[['1', 'ryan farquhar', '498cc bic paton', '102.385 mph', '1:06.19.90'], ['2', 'alan oversby', '500cc norton manx', '101.863 mph', '1:06.40.30'], ['3', 'alan brew', 'seeley g50 496cc', '99.367 mph', '1:08.20.78'], ['4', 'wattie brown', '500cc petty manx', '98.118 mph', '1:09.12.98'], ['5', 'andy reynolds', '499cc bic paton', '97.152 mph', '1:09.54.28'], ['6', 'bob price', '500cc seeley g50', '96.890 mph', '1:10.05.64'], ['7', 'ken davis', '500cc norton manx', '95.948 mph', '1:10.46.92'], ['8', 'chris swallow', '476cc ducati', '95.664 mph', '1:10.59.52'], ['9', 'mark herbertson', '499cc matchless g50', '95.272 mph', '1:11.17.05'], ['10', 'dave madsen - mygdal', '499cc honda', '92.209 mph', '1:11.19.89']]