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(*)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE gas_station (LOCATION VARCHAR) Question: Show all locations and the number of gas stations in each location ordered by the count. [/INST] SELECT LOCATION, COUNT(*) FROM gas_station GROUP BY LOCATION ORDER BY COUNT(*) </s>