HackerRank_01. Revising the Select Query I

문제 : Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.

 

select *
from CITY
where COUNTRYCODE = 'USA'
    AND POPULATION > 100000;

3878 Scottsdale USA Arizona 202705

3965 Corona USA California 124966

3973 Concord USA California 121780

3977 Cedar Rapids USA Iowa 120758

3982 Coral Springs USA Florida 117549