revising-the-select-query-2-mysql

Challenge: 

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

Answer: 

SELECT 
name 
FROM 
city 
WHERE 
    countrycode = 'USA'
    AND population > 120000;