bernard ackah
the average number of points bernard ackah scored in tokyo , japan is 3.5 .
{'scope': 'subset', 'col': '2', 'type': 'average', 'result': '3.5', 'subset': {'col': '8', 'criterion': 'equal', 'value': 'tokyo , japan'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'location', 'tokyo , japan'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; location ; tokyo , japan }', 'tointer': 'select the rows whose location record fuzzily matches to tokyo , japan .'}, 'record'], 'result': '3.5', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; location ; tokyo , japan } ; record }'}, '3.5'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; location ; tokyo , japan } ; record } ; 3.5 } = true', 'tointer': 'select the rows whose location record fuzzily matches to tokyo , japan . the average of the record record of these rows is 3.5 .'}
round_eq { avg { filter_eq { all_rows ; location ; tokyo , japan } ; record } ; 3.5 } = true
select the rows whose location record fuzzily matches to tokyo , japan . the average of the record record of these rows is 3.5 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'location_5': 'location', 'tokyo, japan_6': 'tokyo , japan', 'record_7': 'record', '3.5_8': '3.5'}
['res', 'record', 'opponent', 'method', 'event', 'round', 'time', 'location']
[['win', '5 - 3', 'minoru kato', 'decision ( unanimous )', 'deep : 47th impact', '2', '5:00', 'tokyo , japan'], ['win', '4 - 3', 'shunji kosaka', 'tko ( punches )', 'deep : cage impact 2009', '1', '0:34', 'tokyo , japan'], ['win', '3 - 3', 'ryåshi yanagisawa', 'tko ( head kick and punches )', 'deep : 43rd impact', '1', '0:07', 'tokyo , japan'], ['loss', '2 - 3', 'young choi', 'decision ( unanimous )', 'deep : 42nd impact', '2', '5:00', 'tokyo , japan'], ['loss', '2 - 2', "po'ai suganuma", 'submission ( armbar )', "hero 's 2007 in korea", '1', '3:05', 'seoul , south korea'], ['loss', '2 - 1', 'melvin manhoef', 'ko ( punches )', "hero 's 9", '1', '2:13', 'yokohama , japan'], ['win', '2 - 0', 'johnnie morton', 'ko ( punch )', 'dynamite !! usa', '1', '0:38', 'los angeles , california , usa'], ['win', '1 - 0', 'hyun pyo shin', 'tko ( punches )', "hero 's 8", '1', '1:11', 'nagoya , japan']]