Prepare > SQL > Basic Select > Revising the Select Query I

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.

 

 

 

 

 

코드

---

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