federal league ( ohsaa )
in the federal league , the school that joined second to last was lake .
{'row': '5', 'col': '5', 'order': '2', 'col_other': '1', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'scope': 'all', 'subset': None}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': ['all_rows', 'join date', '2'], 'result': None, 'ind': 0, 'tostr': 'nth_argmax { all_rows ; join date ; 2 }'}, 'school'], 'result': 'lake', 'ind': 1, 'tostr': 'hop { nth_argmax { all_rows ; join date ; 2 } ; school }'}, 'lake'], 'result': True, 'ind': 2, 'tostr': 'eq { hop { nth_argmax { all_rows ; join date ; 2 } ; school } ; lake } = true', 'tointer': 'select the row whose join date record of all rows is 2nd maximum . the school record of this row is lake .'}
eq { hop { nth_argmax { all_rows ; join date ; 2 } ; school } ; lake } = true
select the row whose join date record of all rows is 2nd maximum . the school record of this row is lake .
{'str_eq_2': 'str_eq', 'result_3': 'true', 'str_hop_1': 'str_hop', 'nth_argmax_0': 'nth_argmax', 'all_rows_4': 'all_rows', 'join date_5': 'join date', '2_6': '2', 'school_7': 'school', 'lake_8': 'lake'}
['school', 'nickname', 'location', 'colors', 'join date']
[['canton mckinley', 'bulldogs', 'canton', 'red , black', '2003'], ['glenoak', 'golden eagles', 'canton', 'forest green , vegas gold', '1975'], ['hoover', 'vikings', 'north canton', 'black , orange', '1968'], ['jackson', 'polar bears', 'jackson township', 'purple , gold', '1964'], ['lake', 'blue streaks', 'uniontown', 'blue , red , white', '1987']]