list of schools in the canterbury region
total enrollment in schools in the canterbury region below the 8 decile is 770 .
{'scope': 'subset', 'col': '7', 'type': 'sum', 'result': '770', 'subset': {'col': '6', 'criterion': 'less_than', 'value': '8'}}
{'func': 'round_eq', 'args': [{'func': 'sum', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'decile', '8'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; decile ; 8 }', 'tointer': 'select the rows whose decile record is less than 8 .'}, 'roll'], 'result': '770', 'ind': 1, 'tostr': 'sum { filter_less { all_rows ; decile ; 8 } ; roll }'}, '770'], 'result': True, 'ind': 2, 'tostr': 'round_eq { sum { filter_less { all_rows ; decile ; 8 } ; roll } ; 770 } = true', 'tointer': 'select the rows whose decile record is less than 8 . the sum of the roll record of these rows is 770 .'}
round_eq { sum { filter_less { all_rows ; decile ; 8 } ; roll } ; 770 } = true
select the rows whose decile record is less than 8 . the sum of the roll record of these rows is 770 .
{'eq_2': 'eq', 'result_3': 'true', 'sum_1': 'sum', 'filter_less_0': 'filter_less', 'all_rows_4': 'all_rows', 'decile_5': 'decile', '8_6': '8', 'roll_7': 'roll', '770_8': '770'}
['name', 'years', 'gender', 'area', 'authority', 'decile', 'roll']
[['amberley school', '1 - 8', 'coed', 'amberley', 'state', '7', '230'], ['amuri area school', '1 - 13', 'coed', 'culverden', 'state', '8', '270'], ['broomfield school', '1 - 8', 'coed', 'amberley', 'state', '9', '114'], ['cheviot area school', '1 - 13', 'coed', 'cheviot', 'state', '7', '170'], ['greta valley school', '1 - 8', 'coed', 'greta valley', 'state', '9', '31'], ['hanmer springs school', '1 - 8', 'coed', 'hanmer springs', 'state', '9', '99'], ['hurunui college', '1 - 13', 'coed', 'hawarden', 'state', '7', '236'], ['leithfield school', '1 - 8', 'coed', 'amberley', 'state', '8', '100'], ['omihi school', '1 - 8', 'coed', 'hurunui', 'state', '8', '29'], ['rotherham school', '1 - 6', 'coed', 'rotherham', 'state', '10', '36'], ['waiau school', '1 - 6', 'coed', 'waiau', 'state', '6', '61'], ['waikari school', '1 - 8', 'coed', 'waikari', 'state', '4', '34'], ['waipara school', '1 - 8', 'coed', 'waipara', 'state', '6', '39']]