CREATE TABLE hosting_city (year NUMBER, match_id NUMBER, host_city CLOB)
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)

Which cities have regional population above 10000000?
SELECT city FROM city WHERE regional_population > 10000000
SELECT "city" FROM "city" WHERE "regional_population" > 10000000