[해커랭크/SQL] 1. Revising the Select Query I

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

Revising the Select Query I | HackerRank

---

🤔 문제 분석

1) Query all columns

2) for all American cities in the CITY table

3) with populations larger than 100000.

4) The CountryCode for America is USA.

 

💡 풀이

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