HackerRank_02. Revising the Select Query II

문제 : Query the names of all American cities in CITY with populations larger than 120000. The CountryCode for America is USA.

 

select Name
from CITY
where COUNTRYCODE = 'USA'
    AND POPULATION > 120000;

Scottsdale

Corona

Concord

Cedar Rapids