sheffield shield
in sheffield shield , when the venue was in melbourne , the average number of runs was 397 .
{'scope': 'subset', 'col': '2', 'type': 'average', 'result': '397', 'subset': {'col': '5', 'criterion': 'fuzzily_match', 'value': 'melbourne cricket ground , melbourne'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'venue', 'melbourne cricket ground , melbourne'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; venue ; melbourne cricket ground , melbourne }', 'tointer': 'select the rows whose venue record fuzzily matches to melbourne cricket ground , melbourne .'}, 'runs'], 'result': '397', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; venue ; melbourne cricket ground , melbourne } ; runs }'}, '397'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; venue ; melbourne cricket ground , melbourne } ; runs } ; 397 } = true', 'tointer': 'select the rows whose venue record fuzzily matches to melbourne cricket ground , melbourne . the average of the runs record of these rows is 397 .'}
round_eq { avg { filter_eq { all_rows ; venue ; melbourne cricket ground , melbourne } ; runs } ; 397 } = true
select the rows whose venue record fuzzily matches to melbourne cricket ground , melbourne . the average of the runs record of these rows is 397 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'venue_5': 'venue', 'melbourne cricket ground, melbourne_6': 'melbourne cricket ground , melbourne', 'runs_7': 'runs', '397_8': '397'}
['rank', 'runs', 'player', 'match', 'venue', 'season']
[['1', '452', 'don bradman ( nsw )', 'new south wales v queensland', 'sydney cricket ground , sydney', '1929 - 30'], ['2', '437', 'bill ponsford ( vic )', 'victoria v queensland', 'melbourne cricket ground , melbourne', '1927 - 28'], ['3', '365', 'clem hill ( sa )', 'south australia v new south wales', 'adelaide oval , adalaide', '1900 - 01'], ['4', '359', 'bob simpson ( nsw )', 'new south wales v queensland', 'brisbane cricket ground , brisbane', '1963 - 64'], ['5', '357', 'don bradman ( sa )', 'south australia v victoria', 'melbourne cricket ground , melbourne', '1935 - 36']]