HackerRank: SQL Basic Select "apanese Cities' Attributes"

Question:

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.

HackerRank: SQL Basic Select BY ID

Question:

Query all columns for a city in CITY with the ID 1661.

HackerRank: SQL Basic Select All

Question:

Query all columns (attributes) for every row in the CITY table.

HackerRank: SQL Basic Select 2

Question:

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

HackerRank: SQL Basic Select 1

QUESTION:

Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA.