Database: gas_company
Question: List the company name and rank for all companies in the decreasing order of their sales.
SQL:
SELECT company ,  rank FROM company ORDER BY Sales_billion DESC