[HackerRank](E) Revising the Select Query II

https://www.hackerrank.com/challenges/revising-the-select-query-2/problem?isFullScreen=true 

Revising the Select Query II | HackerRank

 

[문제]

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:

 

[답]

- oracle

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