[hackerrank] Revising the Select Query II

[hackerrank] Prepare > SQL > Basic Select >  Revising the Select Query II

 

[문제]

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.

The CITY table is described as follows:

 

[MYSQL]

 

 

[ORCALE]

select name
from city
where countrycode = 'USA' 
and population > 120000;