2010 - 11 scottish premier league
only three of the premier league stadiums averaged a higher attendance than 10000 fans per game .
{'scope': 'all', 'criterion': 'greater_than', 'value': '10000', 'result': '3', 'col': '7', 'subset': None}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_greater', 'args': ['all_rows', 'average', '10000'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose average record is greater than 10000 .', 'tostr': 'filter_greater { all_rows ; average ; 10000 }'}], 'result': '3', 'ind': 1, 'tostr': 'count { filter_greater { all_rows ; average ; 10000 } }', 'tointer': 'select the rows whose average record is greater than 10000 . the number of such rows is 3 .'}, '3'], 'result': True, 'ind': 2, 'tostr': 'eq { count { filter_greater { all_rows ; average ; 10000 } } ; 3 } = true', 'tointer': 'select the rows whose average record is greater than 10000 . the number of such rows is 3 .'}
eq { count { filter_greater { all_rows ; average ; 10000 } } ; 3 } = true
select the rows whose average record is greater than 10000 . the number of such rows is 3 .
{'eq_2': 'eq', 'result_3': 'true', 'count_1': 'count', 'filter_greater_0': 'filter_greater', 'all_rows_4': 'all_rows', 'average_5': 'average', '10000_6': '10000', '3_7': '3'}
['team', 'stadium', 'capacity', 'total', 'highest', 'lowest', 'average']
[['aberdeen', 'pittodrie stadium', '22199', '173460', '15307', '5955', '9129'], ['celtic', 'celtic park', '60832', '930395', '58874', '40750', '48968'], ['dundee united', 'tannadice park', '14209', '140391', '11790', '4918', '7389'], ['hamilton academical', 'new douglas park', '6096', '55056', '5356', '2011', '2898'], ['heart of midlothian', 'tynecastle stadium', '17420', '269506', '17420', '12009', '14185'], ['inverness ct', 'caledonian stadium', '7500', '85998', '7547', '3241', '4526'], ['kilmarnock', 'rugby park', '18128', '122106', '16173', '4214', '6427'], ['motherwell', 'fir park', '13742', '99838', '9716', '3324', '5255'], ['rangers', 'ibrox stadium', '51082', '860793', '50248', '41514', '45305'], ['st johnstone', 'mcdiarmid park', '10673', '72982', '6866', '2253', '3841']]