CREATE TABLE match (match_id NUMBER, date CLOB, venue CLOB, score CLOB, result CLOB, competition CLOB)
CREATE TABLE city (city_id NUMBER, city CLOB, hanzi CLOB, hanyu_pinyin CLOB, regional_population NUMBER, gdp NUMBER)
CREATE TABLE temperature (city_id NUMBER, jan NUMBER, feb NUMBER, mar NUMBER, apr NUMBER, jun NUMBER, jul NUMBER, aug NUMBER, sep NUMBER, oct NUMBER, nov NUMBER, dec NUMBER)
CREATE TABLE hosting_city (year NUMBER, match_id NUMBER, host_city CLOB)

Which cities have regional population above 8000000 or below 5000000?
SELECT city FROM city WHERE regional_population > 10000000 UNION SELECT city FROM city WHERE regional_population < 5000000
SELECT "city" FROM "city" WHERE "regional_population" > 10000000 UNION SELECT "city" FROM "city" WHERE "regional_population" < 5000000