Show all locations and the number of gas stations in each location ordered by the count.
CREATE TABLE gas_station (LOCATION VARCHAR)
SELECT LOCATION, COUNT(*) FROM gas_station GROUP BY LOCATION ORDER BY COUNT(*)
### Context: CREATE TABLE gas_station (LOCATION VARCHAR) ### Question: Show all locations and the number of gas stations in each location ordered by the count. ### Answer: SELECT LOCATION, COUNT(*) FROM gas_station GROUP BY LOCATION ORDER BY COUNT(*)