ice hockey at the 2010 winter olympics - women 's tournament
the total number of goals scored by canadian players at the 2010 winter olympics women 's ice hockey tournament is 26 .
{'scope': 'subset', 'col': '4', 'type': 'sum', 'result': '26', 'subset': {'col': '2', 'criterion': 'fuzzily_match', 'value': '( can )'}}
{'func': 'round_eq', 'args': [{'func': 'sum', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'player', '( can )'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; player ; ( can ) }', 'tointer': 'select the rows whose player record fuzzily matches to ( can ) .'}, 'goals'], 'result': '26', 'ind': 1, 'tostr': 'sum { filter_eq { all_rows ; player ; ( can ) } ; goals }'}, '26'], 'result': True, 'ind': 2, 'tostr': 'round_eq { sum { filter_eq { all_rows ; player ; ( can ) } ; goals } ; 26 } = true', 'tointer': 'select the rows whose player record fuzzily matches to ( can ) . the sum of the goals record of these rows is 26 .'}
round_eq { sum { filter_eq { all_rows ; player ; ( can ) } ; goals } ; 26 } = true
select the rows whose player record fuzzily matches to ( can ) . the sum of the goals record of these rows is 26 .
{'eq_2': 'eq', 'result_3': 'true', 'sum_1': 'sum', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'player_5': 'player', '( can )_6': '( can )', 'goals_7': 'goals', '26_8': '26'}
['rank', 'player', 'games played', 'goals', 'assists']
[['1', 'meghan agosta ( can )', '5', '9', '6'], ['2', 'jayna hefford ( can )', '5', '5', '7'], ['3', 'stefanie marty ( sui )', '5', '9', '2'], ['4', 'jenny potter ( usa )', '5', '6', '5'], ['5', 'natalie darwitz ( usa )', '5', '4', '7'], ['6', 'caroline ouellette ( can )', '5', '2', '9'], ['6', 'hayley wickenheiser ( can )', '5', '2', '9'], ['8', 'cherie piper ( can )', '5', '5', '5'], ['9', 'monique lamoureux ( usa )', '5', '4', '6'], ['10', 'kelli stack ( usa )', '5', '3', '5'], ['10', 'sarah vaillancourt ( can )', '5', '3', '5']]