real salt lake
for real salt lake the total goals in which the nation was usa was 74 .
{'scope': 'subset', 'col': '5', 'type': 'sum', 'result': '74', 'subset': {'col': '3', 'criterion': 'equal', 'value': 'usa'}}
{'func': 'round_eq', 'args': [{'func': 'sum', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'nation', 'usa'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; nation ; usa }', 'tointer': 'select the rows whose nation record fuzzily matches to usa .'}, 'goals'], 'result': '74', 'ind': 1, 'tostr': 'sum { filter_eq { all_rows ; nation ; usa } ; goals }'}, '74'], 'result': True, 'ind': 2, 'tostr': 'round_eq { sum { filter_eq { all_rows ; nation ; usa } ; goals } ; 74 } = true', 'tointer': 'select the rows whose nation record fuzzily matches to usa . the sum of the goals record of these rows is 74 .'}
round_eq { sum { filter_eq { all_rows ; nation ; usa } ; goals } ; 74 } = true
select the rows whose nation record fuzzily matches to usa . the sum of the goals record of these rows is 74 .
{'eq_2': 'eq', 'result_3': 'true', 'sum_1': 'sum', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'nation_5': 'nation', 'usa_6': 'usa', 'goals_7': 'goals', '74_8': '74'}
['rank', 'player', 'nation', 'games', 'goals', 'years']
[['1', 'nick rimando', 'usa', '201', '0', '2007 - present'], ['2', 'andy williams', 'jam', '189', '14', '2005 - 2011'], ['3', 'kyle beckerman', 'usa', '177', '21', '2007 - present'], ['4', 'chris wingert', 'usa', '174', '1', '2007 - present'], ['5', 'nat borchers', 'usa', '173', '9', '2008 - present'], ['6', 'javier morales', 'arg', '155', '28', '2007 - present'], ['7', 'tony beltran', 'usa', '135', '0', '2008 - present'], ['8', 'ned grabavoy', 'usa', '126', '8', '2009 - present'], ['9', 'fabián espíndola', 'arg', '125', '35', '2007 - 2012'], ['10', 'robbie findley', 'usa', '121', '35', '2007 - 2010 , 2013 - present'], ['11', 'jámison olave', 'col', '120', '10', '2008 - 2012'], ['12', 'will johnson', 'can', '114', '9', '2008 - 2012']]