dancing on ice ( series 3 )
for dancing on ice ( series 3 ) teams earning a total score of over 16.0 , their average public vote % was 10.75 % .
{'scope': 'subset', 'col': '11', 'type': 'average', 'result': '10.75 %', 'subset': {'col': '8', 'criterion': 'greater_than', 'value': '16.0'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'total', '16.0'], 'result': None, 'ind': 0, 'tostr': 'filter_greater { all_rows ; total ; 16.0 }', 'tointer': 'select the rows whose total record is greater than 16.0 .'}, 'public vote %'], 'result': '10.75 %', 'ind': 1, 'tostr': 'avg { filter_greater { all_rows ; total ; 16.0 } ; public vote % }'}, '10.75 %'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_greater { all_rows ; total ; 16.0 } ; public vote % } ; 10.75 % } = true', 'tointer': 'select the rows whose total record is greater than 16.0 . the average of the public vote % record of these rows is 10.75 % .'}
round_eq { avg { filter_greater { all_rows ; total ; 16.0 } ; public vote % } ; 10.75 % } = true
select the rows whose total record is greater than 16.0 . the average of the public vote % record of these rows is 10.75 % .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_greater_0': 'filter_greater', 'all_rows_4': 'all_rows', 'total_5': 'total', '16.0_6': '16.0', 'public vote %_7': 'public vote %', '10.75%_8': '10.75 %'}
['order', 'couple', 'karen', 'nicky', 'jason', 'ruthie', 'robin', 'total', 'scoreboard', 'song', 'public vote %', 'result']
[['1', 'gareth & maria', '4.5', '4.0', '3.5', '3.5', '4.0', '19 , 5', '3rd', 'wake me up when september ends - green day', '6.81 %', 'safe'], ['2', 'linda & daniel', '3.5', '3.0', '3.0', '4.0', '3.0', '16.5', '5th', 'candyman - christina aguilera', '9.09 %', 'safe'], ['3', 'samantha & pavel', '3.5', '3.0', '3.0', '3.5', '3.0', '16.0', '7th', "you ca n't hurry love - the supremes", '3.30 %', 'eliminated'], ['4', 'chris & frankie', '5.0', '5.0', '4.0', '4.5', '5.0', '23.5', '1st', 'rule the world - take that', '19.20 %', 'safe'], ['5', 'aggie & sergey', '2.5', '2.0', '2.0', '3.5', '2.5', '12.5', '10th', 'total eclipse of the heart - bonnie tyler', '5.00 %', 'safe'], ['6', 'steve & susie', '3.0', '3.5', '2.0', '3.0', '3.0', '14.5', '9th', 'mony mony - billy idol', '4.68 %', 'bottom two'], ['7', 'greg & kristina', '3.5', '3.5', '2.5', '3.0', '3.0', '15.5', '8th', 'licence to kill - gladys knight', '12.90 %', 'safe'], ['8', 'zaraah & fred', '4.0', '4.5', '3.0', '3.5', '3.5', '18.5', '4th', 'take a chance on me - abba', '7.88 %', 'safe']]