CREATE TABLE farm (farm_id NUMBER, year NUMBER, total_horses NUMBER, working_horses NUMBER, total_cattle NUMBER, oxen NUMBER, bulls NUMBER, cows NUMBER, pigs NUMBER, sheep_and_goats NUMBER)
CREATE TABLE farm_competition (competition_id NUMBER, year NUMBER, theme CLOB, host_city_id NUMBER, hosts CLOB)
CREATE TABLE competition_record (competition_id NUMBER, farm_id NUMBER, rank NUMBER)
CREATE TABLE city (city_id NUMBER, official_name CLOB, status CLOB, area_km_2 NUMBER, population NUMBER, census_ranking CLOB)

What are the census rankings of cities that do not have the status 'Village'?
SELECT census_ranking FROM city WHERE status <> "Village"
SELECT "census_ranking" FROM "city" WHERE "Village" <> "status"