CREATE TABLE farm_competition (competition_id NUMBER, year NUMBER, theme CLOB, host_city_id NUMBER, hosts CLOB)
CREATE TABLE city (city_id NUMBER, official_name CLOB, status CLOB, area_km_2 NUMBER, population NUMBER, census_ranking CLOB)
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 competition_record (competition_id NUMBER, farm_id NUMBER, rank NUMBER)

Which statuses correspond to both cities that have a population over 1500 and cities that have a population lower than 500?
SELECT status FROM city WHERE population > 1500 INTERSECT SELECT status FROM city WHERE population < 500
SELECT "status" FROM "city" WHERE "population" > 1500 INTERSECT SELECT "status" FROM "city" WHERE "population" < 500