Select * from Car order by MPG asc
 

I am sure this question has been asked before but haven't been able to find the list anywhere.

I am looking to buy myself a new car and would like to see a list of what cars does the best gas milage.

That query would give you the list of cars with the crappiest mileage