Show the rank, company names, market values of all the companies.
select rank, company, market_value from company
What about the results for those in the banking industry?
select rank, company, market_value from company where main_industry = 'Banking'
Order the results by their sales and profits in billion.
select rank, company, market_value from company where main_industry = 'Banking' order by sales_billion, profits_billion