forbes global 2000
the average banking industry company profits shown in the forbes global list in 2000 was 13.9 billion .
{'scope': 'subset', 'col': '6', 'type': 'average', 'result': '13.9 billion', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'banking'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'industry', 'banking'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; industry ; banking }', 'tointer': 'select the rows whose industry record fuzzily matches to banking .'}, 'profits ( billion )'], 'result': '13.9 billion', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; industry ; banking } ; profits ( billion ) }'}, '13.9 billion'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; industry ; banking } ; profits ( billion ) } ; 13.9 billion } = true', 'tointer': 'select the rows whose industry record fuzzily matches to banking . the average of the profits ( billion ) record of these rows is 13.9 billion .'}
round_eq { avg { filter_eq { all_rows ; industry ; banking } ; profits ( billion ) } ; 13.9 billion } = true
select the rows whose industry record fuzzily matches to banking . the average of the profits ( billion ) record of these rows is 13.9 billion .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'industry_5': 'industry', 'banking_6': 'banking', 'profits (billion )_7': 'profits ( billion )', '13.9 billion_8': '13.9 billion'}
['rank', 'company', 'headquarters', 'industry', 'sales ( billion )', 'profits ( billion )', 'assets ( billion )', 'market value ( billion )']
[['01', 'jpmorgan chase', 'usa', 'banking', '115.5', '17.4', '2117.6', '182.2'], ['02', 'hsbc', 'uk', 'banking', '103.3', '13.3', '2467.9', '186.5'], ['03', 'general electric', 'usa', 'conglomerate', '156.2', '11.6', '751.2', '216.2'], ['04', 'exxonmobil', 'usa', 'oil and gas', '341.6', '30.5', '302.5', '407.2'], ['05', 'royal dutch shell', 'netherlands', 'oil and gas', '369.1', '20.1', '317.2', '212.9'], ['06', 'petrochina', 'china', 'oil and gas', '222.3', '21.2', '251.3', '320.8'], ['07', 'industrial and commercial bank of china', 'china', 'banking', '69.2', '18.8', '1723.5', '239.5'], ['08', 'berkshire hathaway', 'usa', 'conglomerate', '136.2', '13', '372.2', '211'], ['08', 'petrobras', 'brazil', 'oil and gas', '121.3', '21.2', '313.2', '238.8'], ['10', 'citigroup', 'usa', 'banking', '111.5', '10.6', '1913.9', '132.8'], ['11', 'bnp paribas', 'france', 'banking', '130.4', '10.5', '2680.7', '88'], ['11', 'wells fargo', 'usa', 'banking', '93.2', '12.4', '1258.1', '170.6'], ['13', 'santander group', 'spain', 'banking', '109.7', '12.8', '1570.6', '94.7'], ['14', 'at & t inc', 'usa', 'telecommunications', '124.3', '19.9', '268.5', '168.2'], ['15', 'gazprom', 'russia', 'oil and gas', '98.7', '25.7', '275.9', '172.9'], ['16', 'chevron', 'usa', 'oil and gas', '189.6', '19', '184.8', '200.6'], ['17', 'china construction bank', 'china', 'banking', '58.2', '15.6', '1408', '224.8'], ['18', 'walmart', 'usa', 'retailing', '421.8', '16.4', '180.7', '187.3'], ['19', 'total', 'france', 'oil and gas', '188.1', '14.2', '192.8', '138'], ['20', 'allianz', 'germany', 'insurance', '142.9', '6.7', '838.4', '62.7']]