2002 grand national
in 2002 grand national , one of age 8 has sp 20/1 .
{'scope': 'subset', 'criterion': 'equal', 'value': '20 / 1', 'result': '1', 'col': '7', 'subset': {'col': '5', 'criterion': 'equal', 'value': '8'}}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_str_eq', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'age', '8'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; age ; 8 }', 'tointer': 'select the rows whose age record is equal to 8 .'}, 'sp', '20 / 1'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose age record is equal to 8 . among these rows , select the rows whose sp record fuzzily matches to 20 / 1 .', 'tostr': 'filter_eq { filter_eq { all_rows ; age ; 8 } ; sp ; 20 / 1 }'}], 'result': '1', 'ind': 2, 'tostr': 'count { filter_eq { filter_eq { all_rows ; age ; 8 } ; sp ; 20 / 1 } }', 'tointer': 'select the rows whose age record is equal to 8 . among these rows , select the rows whose sp record fuzzily matches to 20 / 1 . the number of such rows is 1 .'}, '1'], 'result': True, 'ind': 3, 'tostr': 'eq { count { filter_eq { filter_eq { all_rows ; age ; 8 } ; sp ; 20 / 1 } } ; 1 } = true', 'tointer': 'select the rows whose age record is equal to 8 . among these rows , select the rows whose sp record fuzzily matches to 20 / 1 . the number of such rows is 1 .'}
eq { count { filter_eq { filter_eq { all_rows ; age ; 8 } ; sp ; 20 / 1 } } ; 1 } = true
select the rows whose age record is equal to 8 . among these rows , select the rows whose sp record fuzzily matches to 20 / 1 . the number of such rows is 1 .
{'eq_3': 'eq', 'result_4': 'true', 'count_2': 'count', 'filter_str_eq_1': 'filter_str_eq', 'filter_eq_0': 'filter_eq', 'all_rows_5': 'all_rows', 'age_6': 'age', '8_7': '8', 'sp_8': 'sp', '20 / 1_9': '20 / 1', '1_10': '1'}
['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']]