[해커랭크] Revising the Select Query 1

문제링크 : https://www.hackerrank.com/challenges/revising-the-select-query/problem?isFullScreen=true

 

❓문제

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:

 

❗답

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

---

🤔풀이

간단한 SQL문제이다.

CITY table에서 population이 100000 이상, countrycode가 USA인 항목을 뽑으면 된다.