HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

Problem Statement:Query the names of all Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

Link: HackerRank - Japanese Cities Name

Solution:

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

Explanation:

• SELECT NAME: This part of the query specifies that you want to retrieve the NAME column from the CITY table.
• FROM CITY: Indicates that you are selecting data from the CITY table.
• WHERE COUNTRYCODE = 'JPN': This condition filters the rows to include only those cities where the COUNTRYCODE is 'JPN' (Japan).