Hackerrank – Japanese Cities’ Name

Problem Statement
A description of the problem can be found on Hackerrank.

Solution
Select only Names and filter by CountryCode equals to 'JPN'.

I created solution in:

All solutions are also available on my GitHub.

SQL