2006 african swimming championships
the total number of gold medals won by the top 5 countries in the medal table at the 2006 african swimming championships is 42 .
{'scope': 'subset', 'col': '3', 'type': 'sum', 'result': '42', 'subset': {'col': '1', 'criterion': 'less_than', 'value': '6'}}
{'func': 'round_eq', 'args': [{'func': 'sum', 'args': [{'func': 'filter_less', 'args': ['all_rows', 'rank', '6'], 'result': None, 'ind': 0, 'tostr': 'filter_less { all_rows ; rank ; 6 }', 'tointer': 'select the rows whose rank record is less than 6 .'}, 'gold'], 'result': '42', 'ind': 1, 'tostr': 'sum { filter_less { all_rows ; rank ; 6 } ; gold }'}, '42'], 'result': True, 'ind': 2, 'tostr': 'round_eq { sum { filter_less { all_rows ; rank ; 6 } ; gold } ; 42 } = true', 'tointer': 'select the rows whose rank record is less than 6 . the sum of the gold record of these rows is 42 .'}
round_eq { sum { filter_less { all_rows ; rank ; 6 } ; gold } ; 42 } = true
select the rows whose rank record is less than 6 . the sum of the gold record of these rows is 42 .
{'eq_2': 'eq', 'result_3': 'true', 'sum_1': 'sum', 'filter_less_0': 'filter_less', 'all_rows_4': 'all_rows', 'rank_5': 'rank', '6_6': '6', 'gold_7': 'gold', '42_8': '42'}
['rank', 'nation', 'gold', 'silver', 'bronze', 'total']
[['1', 'south africa', '20', '10', '9', '39'], ['2', 'algeria', '8', '9', '8', '25'], ['3', 'tunisia', '5', '10', '5', '20'], ['4', 'kenya', '4', '4', '1', '9'], ['5', 'egypt', '2', '4', '7', '13'], ['6', 'seychelles', '1', '1', '3', '5'], ['7', 'senegal', '0', '1', '2', '3'], ['7', 'morocco', '0', '1', '2', '3'], ['9', 'zimbabwe', '0', '0', '3', '3'], ['total', 'total', '40', '40', '40', '120']]