list of schools in the otago region
the arrowtown school has a higher decile value than the glenorchy school .
{'row_1': '1', 'row_2': '2', 'col': '6', 'col_other': '1', 'relation': 'greater', 'record_mentioned': 'no', 'diff_result': None}
{'func': 'greater', 'args': [{'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'name', 'arrowtown school'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose name record fuzzily matches to arrowtown school .', 'tostr': 'filter_eq { all_rows ; name ; arrowtown school }'}, 'decile'], 'result': None, 'ind': 2, 'tostr': 'hop { filter_eq { all_rows ; name ; arrowtown school } ; decile }', 'tointer': 'select the rows whose name record fuzzily matches to arrowtown school . take the decile record of this row .'}, {'func': 'num_hop', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'name', 'glenorchy school'], 'result': None, 'ind': 1, 'tointer': 'select the rows whose name record fuzzily matches to glenorchy school .', 'tostr': 'filter_eq { all_rows ; name ; glenorchy school }'}, 'decile'], 'result': None, 'ind': 3, 'tostr': 'hop { filter_eq { all_rows ; name ; glenorchy school } ; decile }', 'tointer': 'select the rows whose name record fuzzily matches to glenorchy school . take the decile record of this row .'}], 'result': True, 'ind': 4, 'tostr': 'greater { hop { filter_eq { all_rows ; name ; arrowtown school } ; decile } ; hop { filter_eq { all_rows ; name ; glenorchy school } ; decile } } = true', 'tointer': 'select the rows whose name record fuzzily matches to arrowtown school . take the decile record of this row . select the rows whose name record fuzzily matches to glenorchy school . take the decile record of this row . the first record is greater than the second record .'}
greater { hop { filter_eq { all_rows ; name ; arrowtown school } ; decile } ; hop { filter_eq { all_rows ; name ; glenorchy school } ; decile } } = true
select the rows whose name record fuzzily matches to arrowtown school . take the decile record of this row . select the rows whose name record fuzzily matches to glenorchy school . take the decile record of this row . the first record is greater than the second record .
{'greater_4': 'greater', 'result_5': 'true', 'num_hop_2': 'num_hop', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_6': 'all_rows', 'name_7': 'name', 'arrowtown school_8': 'arrowtown school', 'decile_9': 'decile', 'num_hop_3': 'num_hop', 'filter_str_eq_1': 'filter_str_eq', 'all_rows_10': 'all_rows', 'name_11': 'name', 'glenorchy school_12': 'glenorchy school', 'decile_13': 'decile'}
['name', 'years', 'gender', 'area', 'authority', 'decile', 'roll']
[['arrowtown school', '1 - 8', 'coed', 'arrowtown', 'state', '10', '498'], ['glenorchy school', '1 - 8', 'coed', 'glenorchy', 'state', '9', '28'], ['hawea flat school', '1 - 6', 'coed', 'hawea flat', 'state', '10', '160'], ['holy family school', '1 - 8', 'coed', 'wanaka', 'state integrated', '10', '122'], ['kingsview school', '1 - 8', 'coed', 'frankton', 'state integrated', '10', '20'], ['makarora primary school', '1 - 8', 'coed', 'makarora', 'state', '7', '15'], ['mount aspiring college', '7 - 13', 'coed', 'wanaka', 'state', '10', '711'], ['queenstown school', '1 - 6', 'coed', 'queenstown', 'state', '10', '627'], ['remarkables primary school', '1 - 8', 'coed', 'frankton', 'state', '10', '495'], ["st joseph 's school", '1 - 8', 'coed', 'queenstown', 'state integrated', '10', '141'], ['wakatipu high school', '9 - 13', 'coed', 'queenstown', 'state', '10', '720'], ['wanaka primary school', '1 - 6', 'coed', 'wanaka', 'state', '10', '527']]