HackerRank SQL Solution - Basic Select - Japanese Cities' Names

• Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - Japanese Cities' Attributes

• Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - Select By ID

• Query all columns for a city in CITY with ID 1661.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - Select All

• Query all columns (attributes) for every row in the CITY table.
• The CITY table is described as follows:

HackerRank SQL Solution - Basic Select - 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 the USA.
• The CITY table is described as follows: