ranking company industry revenue (usd billions) fy capitalization (usd billions) employees listing headquarters ceo
ranking
company
industry
revenue -lrb- usd billions -rrb-
fy
capitalization -lrb- usd billions -rrb-
employees
listing
headquarters
ceo
number
number
number parsed year month day
number
number
address
list length
number text text unitnum date unitnum number text address <s,text>
1 wal-mart stores, inc retail $469 january 31, 2013 $248 2200000 nyse: wmt bentonville, arkansas doug mcmillon
how many companies have at least 200 billion in revenue for oil and gas ?
WRB JJ NNS VBD-AUX IN JJS CD CD IN NN IN NN CC NN .
8
select count ( c2 ) from w where c4_number > 200 and c3 = 'oil and gas'