[MySQL] Revising the Select Query I

 SQL  >  Basic Select  >  Revising the Select Query I 

 Problem 

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:

 

 My Answer 

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