HackerRank SQL Preparation: Japanese Cities' Names(MySQL)

#sql #mysql #writeups #hackerrank

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).