sc 122
for sc 122 , the average tonnage when the flag is the united kingdom is 5983.8 .
{'scope': 'subset', 'col': '4', 'type': 'average', 'result': '5983.8', 'subset': {'col': '3', 'criterion': 'equal', 'value': 'united kingdom'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'flag', 'united kingdom'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; flag ; united kingdom }', 'tointer': 'select the rows whose flag record fuzzily matches to united kingdom .'}, 'tonnage ( grt )'], 'result': '5983.8', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; flag ; united kingdom } ; tonnage ( grt ) }'}, '5983.8'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; flag ; united kingdom } ; tonnage ( grt ) } ; 5983.8 } = true', 'tointer': 'select the rows whose flag record fuzzily matches to united kingdom . the average of the tonnage ( grt ) record of these rows is 5983.8 .'}
round_eq { avg { filter_eq { all_rows ; flag ; united kingdom } ; tonnage ( grt ) } ; 5983.8 } = true
select the rows whose flag record fuzzily matches to united kingdom . the average of the tonnage ( grt ) record of these rows is 5983.8 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'flag_5': 'flag', 'united kingdom_6': 'united kingdom', 'tonnage (grt)_7': 'tonnage ( grt )', '5983.8_8': '5983.8'}
['date', 'name', 'flag', 'tonnage ( grt )', 'sunk by']
[['16 / 17 march 1943', 'kingsbury', 'united kingdom', '4898', 'u - 338'], ['16 / 17 march 1943', 'king gruffydd', 'united kingdom', '5072', 'u - 338'], ['16 / 17 march 1943', 'alderamin', 'netherlands', '7886', 'u - 338'], ['17 march 1943', 'fort cedar lake', 'united kingdom', '7134', 'u - 338 , u - 665'], ['17 march 1943', 'port auckland', 'united kingdom', '8789', 'u - 305'], ['18 march 1943', 'zouave', 'united kingdom', '4256', 'u - 305'], ['18 march 1943', 'granville', 'panama', '4071', 'u - 338'], ['18 / 19 march 1943', 'carras', 'greece', '5234', 'u - 333 , u - 666'], ['19 march 1943', 'clarissa radcliffe', 'united kingdom', '5754', 'u - 663']]