sql notes: hackerrank japanese cities’ names

Problem

Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
Input Format
The CITY table is described as follows:

Analysis

• query the names ==> SELECT NAME
• in the CITY table ==> FROM CITY
• COUNTRYCODE for Japan is JPN ==> COUNTRYCODE = ‘JPN’
• Japanese cities ==> WHERE COUNTRYCODE = ‘JPN’

Solution

1

SELECT NAME FROM CITY WHERE COUNTRYCODE = 'JPN';

Link

Japanese Cities’ Names
(中文版) SQL 笔记: Hackerrank Japanese Cities’ Names