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