Database: gas_company
Question: Show all locations and the number of gas stations in each location ordered by the count.
SQL:
SELECT LOCATION ,  count(*) FROM gas_station GROUP BY LOCATION ORDER BY count(*)