List the names of all the cities.
select official_name from city
Which of these cities have a population bigger than 1500?
select official_name from city where population > 1500
Which cities have a population smaller than 500?
select official_name from city where population < 500
Show all statuses that are common between these two types of cities.
select status from city where population > 1500 intersect select status from city where population < 500