For each location, how many gas stations are there in order?
SELECT LOCATION ,  count(*) FROM gas_station GROUP BY LOCATION ORDER BY count(*)
for each location = GROUP BY LOCATION; number of gas stations = COUNT(*); in order = ORDER BY COUNT(*) ASC (ascending order by default);