[hackerrank] Revising the Select Query I

Prepare > SQL > Basic Select > Revising the Select Query I

 

 

[문제]

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:

[MYSQL]

select *
from city
where countrycode = 'USA' 
and population > 100000 ;

 

[ORACLE]

select *
from city
where countrycode = 'USA'
and population > 100000;