1990 - 91 argentine primera división
in the 1990-91 argentinian primera división , huracán was the only team that played fewer than 114 games and still maintained an average above 1.0 .
{'scope': 'subset', 'row': '7', 'col': '2', 'col_other': '1', 'criterion': 'greater_than', 'value': '1.0', 'subset': {'col': '4', 'criterion': 'less_than', 'value': '114'}}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'played', '114'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; played ; 114 }', 'tointer': 'select the rows whose played record is less than 114 .'}, 'average', '1.0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose played record is less than 114 . among these rows , select the rows whose average record is greater than 1.0 .', 'tostr': 'filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 }'}], 'result': True, 'ind': 2, 'tostr': 'only { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } }', 'tointer': 'select the rows whose played record is less than 114 . among these rows , select the rows whose average record is greater than 1.0 . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_greater', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'played', '114'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; played ; 114 }', 'tointer': 'select the rows whose played record is less than 114 .'}, 'average', '1.0'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose played record is less than 114 . among these rows , select the rows whose average record is greater than 1.0 .', 'tostr': 'filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 }'}, 'team'], 'result': 'huracán', 'ind': 3, 'tostr': 'hop { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } ; team }'}, 'huracán'], 'result': True, 'ind': 4, 'tostr': 'eq { hop { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } ; team } ; huracán }', 'tointer': 'the team record of this unqiue row is huracán .'}], 'result': True, 'ind': 5, 'tostr': 'and { only { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } } ; eq { hop { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } ; team } ; huracán } } = true', 'tointer': 'select the rows whose played record is less than 114 . among these rows , select the rows whose average record is greater than 1.0 . there is only one such row in the table . the team record of this unqiue row is huracán .'}
and { only { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } } ; eq { hop { filter_greater { filter_less { all_rows ; played ; 114 } ; average ; 1.0 } ; team } ; huracán } } = true
select the rows whose played record is less than 114 . among these rows , select the rows whose average record is greater than 1.0 . there is only one such row in the table . the team record of this unqiue row is huracán .
{'and_5': 'and', 'result_6': 'true', 'only_2': 'only', 'filter_greater_1': 'filter_greater', 'filter_less_0': 'filter_less', 'all_rows_7': 'all_rows', 'played_8': 'played', '114_9': '114', 'average_10': 'average', '1.0_11': '1.0', 'str_eq_4': 'str_eq', 'str_hop_3': 'str_hop', 'team_12': 'team', 'huracán_13': 'huracán'}
['team', 'average', 'points', 'played', '1988 - 89', '1989 - 90', '1990 - 1991']
[['boca juniors', '1.254', '143', '114', '49', '43', '51'], ['river plate', '1.254', '143', '114', '45', '53', '45'], ['independiente', '1.237', '141', '114', '55', '46', '40'], ['san lorenzo', '1.070', '122', '114', '42', '35', '45'], ['racing club', '1.061', '121', '114', '42', '39', '40'], ['vélez sársfield', '1.053', '120', '114', '33', '42', '45'], ['huracán', '1.053', '40', '38', 'n / a', 'n / a', '40'], ["newell 's old boys", '1.044', '119', '114', '35', '36', '48'], ['rosario central', '1.035', '118', '114', '36', '43', '39'], ['argentinos juniors', '1.018', '116', '114', '42', '38', '36'], ['estudiantes de la plata', '1.009', '115', '114', '42', '34', '39'], ['talleres de córdoba', '0.956', '109', '114', '44', '36', '29'], ['gimnasia de la plata', '0.947', '108', '114', '36', '39', '33'], ['ferro carril oeste', '0.939', '107', '114', '30', '39', '38'], ['deportivo mandiyú', '0.939', '107', '114', '33', '36', '38'], ['deportivo español', '0.921', '105', '114', '46', '31', '28'], ['platense', '0.912', '104', '114', '33', '36', '35'], ['unión de santa fe', '0.882', '67', '76', 'n / a', '36', '31'], ['chaco for ever', '0.789', '60', '76', 'n / a', '32', '28']]