1985 european aquatics championships
the top 5 ranking countries in the 1985 european aquatics championships averaged a total of 4 bronze medals won .
{'scope': 'subset', 'col': '5', 'type': 'average', 'result': '4', 'subset': {'col': '1', 'criterion': 'less_than_eq', 'value': '5'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_less_eq', 'args': ['all_rows', 'rank', '5'], 'result': None, 'ind': 0, 'tostr': 'filter_less_eq { all_rows ; rank ; 5 }', 'tointer': 'select the rows whose rank record is less than or equal to 5 .'}, 'bronze'], 'result': '4', 'ind': 1, 'tostr': 'avg { filter_less_eq { all_rows ; rank ; 5 } ; bronze }'}, '4'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_less_eq { all_rows ; rank ; 5 } ; bronze } ; 4 } = true', 'tointer': 'select the rows whose rank record is less than or equal to 5 . the average of the bronze record of these rows is 4 .'}
round_eq { avg { filter_less_eq { all_rows ; rank ; 5 } ; bronze } ; 4 } = true
select the rows whose rank record is less than or equal to 5 . the average of the bronze record of these rows is 4 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_less_eq_0': 'filter_less_eq', 'all_rows_4': 'all_rows', 'rank_5': 'rank', '5_6': '5', 'bronze_7': 'bronze', '4_8': '4'}
['rank', 'nation', 'gold', 'silver', 'bronze', 'total']
[['1', 'east germany', '17', '17', '6', '40'], ['2', 'soviet union', '7', '4', '6', '17'], ['3', 'west germany', '6', '4', '7', '17'], ['4', 'great britain', '2', '3', '1', '6'], ['5', 'france', '2', '2', '0', '4'], ['6', 'hungary', '2', '1', '0', '3'], ['7', 'bulgaria', '1', '2', '4', '7'], ['8', 'netherlands', '1', '1', '6', '8'], ['9', 'austria', '1', '0', '1', '2'], ['10', 'sweden', '0', '1', '3', '4'], ['11', 'czechoslovakia', '0', '1', '1', '2'], ['12', 'denmark', '0', '1', '0', '1'], ['12', 'portugal', '0', '1', '0', '1'], ['12', 'yugoslavia', '0', '1', '0', '1'], ['15', 'italy', '0', '0', '2', '2'], ['15', 'switzerland', '0', '0', '2', '2'], ['total', 'total', '39', '39', '39', '117']]