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';

Enter fullscreen mode
Exit fullscreen mode

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

Subscribe to get the latest posts sent to your email.