HackerRank / Revising the Select Query 1

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 CountryCode = 'USA' and POPULATION > 100000