[SQL] Revising the Select Query I

✅ Revising the Select Query I

---

📝 문제

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';

---