CREATE TABLE gas_station (LOCATION VARCHAR)

Show all locations and the number of gas stations in each location ordered by the count.
SELECT LOCATION, COUNT(*) FROM gas_station GROUP BY LOCATION ORDER BY COUNT(*)
SELECT "LOCATION", COUNT(*) FROM "gas_station" GROUP BY "LOCATION" ORDER BY COUNT(*) NULLS FIRST