calgary - edmonton corridor
in the calgary - edmonton corridor , division no 11 has the highest area ( km square ) among those with pop ( 1996 ) less than 1000000 .
{'scope': 'subset', 'row': '3', 'col': '2', 'order': '1', 'col_other': '1', 'max_or_min': 'max_to_min', 'value_mentioned': 'no', 'subset': {'col': '6', 'criterion': 'less_than', 'value': '1000000'}}
{'func': 'str_eq', 'args': [{'func': 'str_hop', 'args': [{'func': 'nth_argmax', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'pop ( 1996 )', '1000000'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; pop ( 1996 ) ; 1000000 }', 'tointer': 'select the rows whose pop ( 1996 ) record is less than 1000000 .'}, 'area ( km square )', '1'], 'result': None, 'ind': 1, 'tostr': 'nth_argmax { filter_less { all_rows ; pop ( 1996 ) ; 1000000 } ; area ( km square ) ; 1 }'}, 'census division'], 'result': 'division no 11', 'ind': 2, 'tostr': 'hop { nth_argmax { filter_less { all_rows ; pop ( 1996 ) ; 1000000 } ; area ( km square ) ; 1 } ; census division }'}, 'division no 11'], 'result': True, 'ind': 3, 'tostr': 'eq { hop { nth_argmax { filter_less { all_rows ; pop ( 1996 ) ; 1000000 } ; area ( km square ) ; 1 } ; census division } ; division no 11 } = true', 'tointer': 'select the rows whose pop ( 1996 ) record is less than 1000000 . select the row whose area ( km square ) record of these rows is 1st maximum . the census division record of this row is division no 11 .'}
eq { hop { nth_argmax { filter_less { all_rows ; pop ( 1996 ) ; 1000000 } ; area ( km square ) ; 1 } ; census division } ; division no 11 } = true
select the rows whose pop ( 1996 ) record is less than 1000000 . select the row whose area ( km square ) record of these rows is 1st maximum . the census division record of this row is division no 11 .
{'str_eq_3': 'str_eq', 'result_4': 'true', 'str_hop_2': 'str_hop', 'nth_argmax_1': 'nth_argmax', 'filter_less_0': 'filter_less', 'all_rows_5': 'all_rows', 'pop (1996)_6': 'pop ( 1996 )', '1000000_7': '1000000', 'area (km square)_8': 'area ( km square )', '1_9': '1', 'census division_10': 'census division', 'division no 11_11': 'division no 11'}
['census division', 'area ( km square )', 'pop ( 2011 )', 'pop ( 2006 )', 'pop ( 2001 )', 'pop ( 1996 )']
[['division no 6', '12645.88', '1311022', '1160936', '1021060', '880859'], ['division no 8', '9909.31', '189243', '175337', '153049', '133592'], ['division no 11', '15767.99', '1203115', '1076103', '975477', '898888'], ['calgary - edmonton corridor', '38323.18', '2703380', '2412376', '2149586', '1913339'], ['province of alberta', '640081.87', '3645257', '3290350', '2974807', '2696826']]