What is the average market value
select avg ( market_value ) from company
Which company is the most profitable?
select company from company order by assets_billion desc limit 1
What is the average sales of the companies ranked 1, 2 and 3?
select avg ( sales_billion ) from company where rank = 1 or rank = 2 or rank = 3