northern state conference ( ihsaa )
bremen is the newest member school to join the northern state conference ( ihsaa ) .
{'scope': 'all', 'col_superlative': '7', 'row_superlative': '1', 'value_mentioned': 'no', 'max_or_min': 'max', 'other_col': '1', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'argmax', 'args': ['all_rows', 'year joined'], 'result': None, 'ind': 0, 'tostr': 'argmax { all_rows ; year joined }'}, 'school ( ihsaa id )'], 'result': 'bremen', 'ind': 1, 'tostr': 'hop { argmax { all_rows ; year joined } ; school ( ihsaa id ) }'}, 'bremen'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { argmax { all_rows ; year joined } ; school ( ihsaa id ) } ; bremen } = true', 'tointer': 'select the row whose year joined record of all rows is maximum . the school ( ihsaa id ) record of this row is bremen .'}
eq { hop { argmax { all_rows ; year joined } ; school ( ihsaa id ) } ; bremen } = true
select the row whose year joined record of all rows is maximum . the school ( ihsaa id ) record of this row is bremen .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'argmax_0': 'argmax', 'all_rows_4': 'all_rows', 'year joined_5': 'year joined', 'school (ihsaa id)_6': 'school ( ihsaa id )', 'bremen_7': 'bremen'}
['school ( ihsaa id )', 'location', 'mascot', 'enrollment', 'ihsaa class', 'county', 'year joined']
[['bremen', 'bremen', 'lions', '505', 'aa', '50 marshall', '1989'], ['culver community', 'culver', 'cavaliers', '306', 'a', '50 marshall', '1977'], ['glenn', 'walkerton', 'falcons', '613', 'aaa', '71 st joseph', '1966'], ['jimtown', 'elkhart', 'jimmies', '642', 'aaa', '20 elkhart', '1966'], ['knox community', 'knox', 'redskins', '632', 'aaa', '75 starke', '1982'], ['laville', 'lakeville', 'lancers', '413', 'a', '71 st joseph', '1966'], ['new prairie', 'new carlisle', 'cougars', '859', 'aaaa', '46 laporte 71 st joseph', '1968'], ['triton', 'bourbon', 'trojans', '333', 'a', '50 marshall', '1980']]