2002 grand national
richard johnson got the highest position in those of sp 10/1 in the 2002 grand national .
{'scope': 'subset', 'row': '2', 'col': '1', 'order': '1', 'col_other': '4', 'max_or_min': 'min_to_max', 'value_mentioned': 'no', 'subset': {'col': '7', 'criterion': 'equal', 'value': '10 / 1'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmin', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'sp', '10 / 1'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; sp ; 10 / 1 }', 'tointer': 'select the rows whose sp record fuzzily matches to 10 / 1 .'}, 'position', '1'], 'result': None, 'ind': 1, 'tostr': 'nth_argmin { filter_eq { all_rows ; sp ; 10 / 1 } ; position ; 1 }'}, 'jockey'], 'result': 'richard johnson', 'ind': 2, 'tostr': 'hop { nth_argmin { filter_eq { all_rows ; sp ; 10 / 1 } ; position ; 1 } ; jockey }'}, 'richard johnson'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { nth_argmin { filter_eq { all_rows ; sp ; 10 / 1 } ; position ; 1 } ; jockey } ; richard johnson } = true', 'tointer': 'select the rows whose sp record fuzzily matches to 10 / 1 . select the row whose position record of these rows is 1st minimum . the jockey record of this row is richard johnson .'}
eq { hop { nth_argmin { filter_eq { all_rows ; sp ; 10 / 1 } ; position ; 1 } ; jockey } ; richard johnson } = true
select the rows whose sp record fuzzily matches to 10 / 1 . select the row whose position record of these rows is 1st minimum . the jockey record of this row is richard johnson .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'nth_argmin_1': 'nth_argmin', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_5': 'all_rows', 'sp_6': 'sp', '10 / 1_7': '10 / 1', 'position_8': 'position', '1_9': '1', 'jockey_10': 'jockey', 'richard johnson_11': 'richard johnson'}
['position', 'number', 'horse', 'jockey', 'age', 'handicap', 'sp', 'distance']
[['1st', '21', 'bindaree', 'jim culloty', '8', '10 - 4', '20 / 1', 'won by 1 ¾ lengths'], ['2nd', '4', "what 's up boys", 'richard johnson', '8', '11 - 6', '10 / 1', '27 lengths'], ['3rd', '16', 'blowing wind', 'tony mccoy', '9', '10 - 6', '10 / 1', '9 lengths'], ['4th', '3', 'kingsmark', 'ruby walsh', '9', '11 - 9', '16 / 1', '17 lengths'], ['5th', '40', 'supreme charm', 'robert thornton', '10', '10 - 0', '28 / 1', '3 ½ lengths'], ['6th', '22', 'celibate', 'noel fehily', '11', '10 - 3', '66 / 1', '3 ½ lengths'], ['7th', '13', "you 're agoodun", 'johnny kavanagh', '10', '10 - 8', '50 / 1', '18 lengths'], ['8th', '14', 'royal predica', 'jimmy mccarthy', '8', '10 - 8', '80 / 1', '28 lengths'], ['9th', '12', 'streamstown', 'john mcnamara', '8', '10 - 8', '40 / 1', '13 lengths'], ['10th', '34', 'birkdale', 'jason maguire', '11', '10 - 2', '50 / 1', 'a distance']]