[해커랭크/SQL] 2. Revising the Select Query II

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

Revising the Select Query II | HackerRank

---

🤔 문제 분석

1) Query the NAME field

2) for all American cities in the CITY table

3) with populations larger than 120000.

4) The CountryCode for America is USA.

 

💡 풀이

SELECT NAME
FROM CITY
WHERE POPULATION > 120000
AND COUNTRYCODE = "USA"