indiana high school athletics conferences : mid - eastern - northwestern
indian creek is the only school with ' aaa ' ihsaa class in the indiana high school athletics conference .
{'scope': 'all', 'row': '3', 'col': '5', 'col_other': '1', 'criterion': 'equal', 'value': 'aaa', 'subset': None}
{'func': 'and', 'args': [{'func': 'only', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'ihsaa class', 'aaa'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose ihsaa class record fuzzily matches to aaa .', 'tostr': 'filter_eq { all_rows ; ihsaa class ; aaa }'}], 'result': True, 'ind': 1, 'tostr': 'only { filter_eq { all_rows ; ihsaa class ; aaa } }', 'tointer': 'select the rows whose ihsaa class record fuzzily matches to aaa . there is only one such row in the table .'}, {'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'ihsaa class', 'aaa'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose ihsaa class record fuzzily matches to aaa .', 'tostr': 'filter_eq { all_rows ; ihsaa class ; aaa }'}, 'school'], 'result': 'indian creek', 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; ihsaa class ; aaa } ; school }'}, 'indian creek'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { filter_eq { all_rows ; ihsaa class ; aaa } ; school } ; indian creek }', 'tointer': 'the school record of this unqiue row is indian creek .'}], 'result': True, 'ind': 4, 'tostr': 'and { only { filter_eq { all_rows ; ihsaa class ; aaa } } ; eq { hop { filter_eq { all_rows ; ihsaa class ; aaa } ; school } ; indian creek } } = true', 'tointer': 'select the rows whose ihsaa class record fuzzily matches to aaa . there is only one such row in the table . the school record of this unqiue row is indian creek .'}
and { only { filter_eq { all_rows ; ihsaa class ; aaa } } ; eq { hop { filter_eq { all_rows ; ihsaa class ; aaa } ; school } ; indian creek } } = true
select the rows whose ihsaa class record fuzzily matches to aaa . there is only one such row in the table . the school record of this unqiue row is indian creek .
{'and_4': 'and', 'result_5': 'true', 'only_1': 'only', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'ihsaa class_7': 'ihsaa class', 'aaa_8': 'aaa', 'str_eq_3': 'str_eq', 'str_hop_2': 'str_hop', 'school_9': 'school', 'indian creek_10': 'indian creek'}
['school', 'location', 'mascot', 'enrollment', 'ihsaa class', 'county']
[['edinburgh community', 'edinburgh', 'lancers', '269', 'a', '41 johnson'], ['hauser', 'hope', 'jets', '297', 'a', '03 bartholomew'], ['indian creek', 'trafalgar', 'braves', '608', 'aaa', '41 johnson'], ['morristown', 'morristown', 'yellow jackets', '231', 'a', '73 shelby'], ['north decatur', 'greensburg', 'chargers', '369', 'aa', '16 decatur'], ['south decatur', 'greensburg', 'cougars', '292', 'a', '16 decatur'], ['southwestern shelbyville', 'shelbyville', 'spartans', '218', 'a', '73 shelby'], ['triton central', 'fairland', 'tigers', '525', 'aa', '73 shelby'], ['waldron', 'waldron', 'mohawks', '237', 'a', '73 shelby']]