[MySQL/HackerRank] 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"

 

HackerRank MySQL EASY