Database: gas_company
Question: For each location, how many gas stations are there in order?
SQL:
SELECT LOCATION ,  count(*) FROM gas_station GROUP BY LOCATION ORDER BY count(*)