CREATE TABLE gas_station (station_id DECIMAL, open_year DECIMAL, location TEXT, manager_name TEXT, vice_manager_name TEXT, representative_name TEXT)
CREATE TABLE station_company (station_id DECIMAL, company_id DECIMAL, rank_of_the_year DECIMAL)
CREATE TABLE company (company_id DECIMAL, rank DECIMAL, company TEXT, headquarters TEXT, main_industry TEXT, sales_billion DECIMAL, profits_billion DECIMAL, assets_billion DECIMAL, market_value DECIMAL)

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