forbes global 2000
2 companies in the oil & gas industry are listed in the forbes global 2000 rankings .
{'scope': 'all', 'criterion': 'equal', 'value': 'oil & gas', 'result': '2', 'col': '4', 'subset': None}
{'func': 'eq', 'args': [{'func': 'count', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'industry', 'oil & gas'], 'result': None, 'ind': 0, 'tointer': 'select the rows whose industry record fuzzily matches to oil & gas .', 'tostr': 'filter_eq { all_rows ; industry ; oil & gas }'}], 'result': '2', 'ind': 1, 'tostr': 'count { filter_eq { all_rows ; industry ; oil & gas } }', 'tointer': 'select the rows whose industry record fuzzily matches to oil & gas . the number of such rows is 2 .'}, '2'], 'result': True, 'ind': 2, 'tostr': 'eq { count { filter_eq { all_rows ; industry ; oil & gas } } ; 2 } = true', 'tointer': 'select the rows whose industry record fuzzily matches to oil & gas . the number of such rows is 2 .'}
eq { count { filter_eq { all_rows ; industry ; oil & gas } } ; 2 } = true
select the rows whose industry record fuzzily matches to oil & gas . the number of such rows is 2 .
{'eq_2': 'eq', 'result_3': 'true', 'count_1': 'count', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'industry_5': 'industry', 'oil & gas_6': 'oil & gas', '2_7': '2'}
['rank', 'company', 'headquarters', 'industry', 'sales ( billion )', 'profits ( billion )', 'assets ( billion )', 'market value ( billion )']
[['1', 'citigroup', 'usa', 'banking', '94.71', '17.85', '1264.03', '255.30'], ['2', 'general electric', 'usa', 'conglomerates', '134.19', '15.59', '626.93', '328.54'], ['3', 'american international group', 'usa', 'insurance', '76.66', '6.46', '647.66', '194.87'], ['4', 'exxonmobil', 'usa', 'oil & gas', '222.88', '20.96', '166.99', '277.02'], ['5', 'bp', 'uk', 'oil & gas', '232.57', '10.27', '177.57', '173.54'], ['6', 'bank of america', 'usa', 'banking', '49.01', '10.81', '736.45', '117.55'], ['7', 'hsbc', 'uk', 'banking', '44.33', '6.66', '757.60', '177.96'], ['8', 'toyota', 'japan', 'automotive', '135.82', '7.99', '171.71', '115.40'], ['9', 'fannie mae', 'usa', 'diversified financials', '53.13', '6.48', '1019.17', '76.84'], ['10', 'walmart', 'usa', 'ing retail', '256.33', '9.05', '104.91', '243.74']]