Show the census ranking of cities whose status are not "Village".
CREATE TABLE city (Census_Ranking VARCHAR, Status VARCHAR)
SELECT Census_Ranking FROM city WHERE Status <> "Village"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE city (Census_Ranking VARCHAR, Status VARCHAR) Question: Show the census ranking of cities whose status are not "Village". [/INST] SELECT Census_Ranking FROM city WHERE Status <> "Village" </s>