Revising the Select Query II

Query the city names for all American cities with populations larger than 120,000.

Problem

Link to HackerRank Challenge: Revising the Select Query II

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

The CITY table is described as follows:

For illustration purpose, a database named hackerrank_db is created.
In this hackerrank_db, a table named city is created.
In this city table, test data is inserted. Querying this table produces following output.

select * from city

id	name	countrycode	district	population
1	city_1	IND	IND_district_1	100000
2	city_2	IND	IND_district_1	110000
3	city_3	IND	IND_district_2	120000
4	city_4	IND	IND_district_3	130000
5	city_5	IND	IND_district_4	140000
6	city_6	USA	USA_district_1	100000
7	city_7	USA	USA_district_1	110000
8	city_8	USA	USA_district_2	120000
9	city_9	USA	USA_district_3	130000
10	city_10	USA	USA_district_4	140000
11	city_11	JPN	JPN_district_1	100000
12	city_12	JPN	JPN_district_1	110000
13	city_13	JPN	JPN_district_2	120000
14	city_14	JPN	JPN_district_3	130000
1661	city_1661	JPN	JPN_district_4	140000

Expected output should contain:

only name of the city
only USA data: So, query should include where clause on countrycode column to filter out other countries data
only cities with populations larger than 120000: So, where clause should also be applied on population column. Both of these conditions can be combined using and operator.

select * from city where countrycode = 'USA' and population > 120000

id	name	countrycode	district	population
9	city_9	USA	USA_district_3	130000
10	city_10	USA	USA_district_4	140000

select name from city where countrycode = 'USA' and population > 120000

name
city_9
city_10