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 theNAME
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 theCOUNTRYCODE
is 'JPN' (Japan).
Top comments (0)