Table: east_asia_cities
Columns: city
chinese
pinyin
province
urban_population_2010
administrative_population_2010

Question: What province has the Chinese translation 重庆?
SQL: SELECT COUNT("province") FROM east_asia_cities WHERE "chinese" = '重庆'

Question: What is the total administrative population of Shanghai?
SQL: SELECT COUNT("administrative_population_2010") FROM east_asia_cities WHERE "city" = 'Shanghai'

Question: What is the maximum administrative population of the city with Chinese translation 昆明?
SQL: SELECT MAX("administrative_population_2010") FROM east_asia_cities WHERE "chinese" = '昆明'

Question: What is the total urban population of the city with the pinyin translation chángchūn?
SQL: SELECT COUNT("urban_population_2010") FROM east_asia_cities WHERE "pinyin" = 'Chángchūn'