문제
Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.
The CITY table is described as follows:
정답
SELECT *
FROM CITY
WHERE COUNTRYCODE = 'USA' and POPULATION > 100000;
SQL
복사