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 oil and gas industries made the top 10 in ranking of revenue list ?
WRB JJ NN CC NN NNS VBD DT JJ CD IN NN IN NN NN .
6
select count ( c2 ) from w where c3 = 'oil and gas' and c1_number <= 10