list of corporations by market capitalization
for corporations whose primary industry is healthcare , the average market value , in usd millions , is 151413.5 .
{'scope': 'subset', 'col': '5', 'type': 'average', 'result': '151413.5', 'subset': {'col': '4', 'criterion': 'equal', 'value': 'health care'}}
{'func': 'round_eq', 'args': [{'func': 'avg', 'args': [{'func': 'filter_str_eq', 'args': ['all_rows', 'primary industry', 'health care'], 'result': None, 'ind': 0, 'tostr': 'filter_eq { all_rows ; primary industry ; health care }', 'tointer': 'select the rows whose primary industry record fuzzily matches to health care .'}, 'market value ( usd million )'], 'result': '151413.5', 'ind': 1, 'tostr': 'avg { filter_eq { all_rows ; primary industry ; health care } ; market value ( usd million ) }'}, '151413.5'], 'result': True, 'ind': 2, 'tostr': 'round_eq { avg { filter_eq { all_rows ; primary industry ; health care } ; market value ( usd million ) } ; 151413.5 } = true', 'tointer': 'select the rows whose primary industry record fuzzily matches to health care . the average of the market value ( usd million ) record of these rows is 151413.5 .'}
round_eq { avg { filter_eq { all_rows ; primary industry ; health care } ; market value ( usd million ) } ; 151413.5 } = true
select the rows whose primary industry record fuzzily matches to health care . the average of the market value ( usd million ) record of these rows is 151413.5 .
{'eq_2': 'eq', 'result_3': 'true', 'avg_1': 'avg', 'filter_str_eq_0': 'filter_str_eq', 'all_rows_4': 'all_rows', 'primary industry_5': 'primary industry', 'health care_6': 'health care', 'market value ( usd million)_7': 'market value ( usd million )', '151413.5_8': '151413.5'}
['rank', 'name', 'headquarters', 'primary industry', 'market value ( usd million )']
[['1', 'microsoft', 'united states', 'software industry', '271854'], ['2', 'general electric', 'united states', 'conglomerate', '258871'], ['3', 'exxon mobil', 'united states', 'oil and gas', '172213'], ['4', 'royal dutch shell', 'the netherlands', 'oil and gas', '164157'], ['5', 'merck', 'united states', 'health care', '154753'], ['6', 'pfizer', 'united states', 'health care', '148074'], ['7', 'intel corporation', 'united states', 'computer hardware', '144060'], ['8', 'the coca - cola company', 'united states', 'beverage', '142164'], ['9', 'wal - mart', 'united states', 'retail', '123062'], ['10', 'ibm', 'united states', 'software industry , computer hardware', '121184']]