[MYSQL] HACKERRANK - Revising the Select Query I

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

Revising the Select Query I | HackerRank

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:

기본 WHERE문 사용 문제

 

Countrycode 가 USA

POUPLATION 이 10만 초과인 경우

 

코드

SELECT *
FROM CITY
WHERE POPULATION > 100000 AND COUNTRYCODE = 'USA';