2. Revising the SELECT Query II: Solution

---

Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is “USA”.

The CITY table is described as follows:

We need to select only the NAME column from CITY, where COUNTRYCODE='USA' and POPULATION > 120000. So, our query will be as follows

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

Back to problems

---

anusha-murali.github.io