football records in spain
for the football records in spain , of the clubs 38 apps , the only one with 91 points is barcelona .
{'scope': 'subset', 'row': '8', 'col': '4', 'col_other': '2,5', 'criterion': 'equal', 'value': '91', 'subset': {'col': '5', 'criterion': 'equal', 'value': '38'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'apps', '38'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; apps ; 38 }', 'tointer': 'select the rows whose apps record is equal to 38 .'}, 'points', '91'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose apps record is equal to 38 . among these rows , select the rows whose points record is equal to 91 .', 'tostr': 'filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } }', 'tointer': 'select the rows whose apps record is equal to 38 . among these rows , select the rows whose points record is equal to 91 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_eq', 'args': [{'func': 'filter_eq', 'args': ['all_rows', 'apps', '38'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; apps ; 38 }', 'tointer': 'select the rows whose apps record is equal to 38 .'}, 'points', '91'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose apps record is equal to 38 . among these rows , select the rows whose points record is equal to 91 .', 'tostr': 'filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 }'}, 'club'], 'result': 'barcelona', 'ind': 3, 'tostr': 'hop { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } ; club }'}, 'barcelona'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } ; club } ; barcelona }', 'tointer': 'the club record of this unqiue row is barcelona .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } } ; eq { hop { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } ; club } ; barcelona } } = true', 'tointer': 'select the rows whose apps record is equal to 38 . among these rows , select the rows whose points record is equal to 91 . there is only one such row in the table . the club record of this unqiue row is barcelona .'}
and { only { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } } ; eq { hop { filter_eq { filter_eq { all_rows ; apps ; 38 } ; points ; 91 } ; club } ; barcelona } } = true
select the rows whose apps record is equal to 38 . among these rows , select the rows whose points record is equal to 91 . there is only one such row in the table . the club record of this unqiue row is barcelona .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_eq_1': 'filter_eq', 'filter_eq_0': 'filter_eq', 'all_rows_7': 'all_rows', 'apps_8': 'apps', '38_9': '38', 'points_10': 'points', '91_11': '91', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'club_12': 'club', 'barcelona_13': 'barcelona'}
['rank', 'club', 'season', 'points', 'apps']
[['1', 'real madrid', '2011 / 12', '100', '38'], ['1', 'barcelona', '2012 / 13', '100', '38'], ['3', 'barcelona', '2009 / 10', '99', '38'], ['4', 'real madrid', '2009 / 10', '96', '38'], ['4', 'barcelona', '2010 / 11', '96', '38'], ['6', 'real madrid', '2010 / 11', '92', '38'], ['7', 'real madrid', '1996 / 97', '92', '42'], ['8', 'barcelona', '2011 / 12', '91', '38'], ['9', 'barcelona', '1996 / 97', '90', '42']]