[MySQL/HackerRank] Revising the Select Query I

Question

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:

My Answer

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

Result

 

 

출처 : https://www.hackerrank.com/challenges/revising-the-select-query/problem

Revising the Select Query I | HackerRank