Revising the Select Query I - SQL

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:

Language: MySQL

Open in editor

 

1

SELECT * FROM CITY

2

WHERE POPULATION> 100000 AND COUNTRYCODE = "USA"