CREATE TABLE city (Census_Ranking VARCHAR2, Status VARCHAR2)

Show the census ranking of cities whose status are not 'Village'.
SELECT Census_Ranking FROM city WHERE Status <> "Village"
SELECT "Census_Ranking" FROM "city" WHERE "Status" <> "Village"