Hackerrank – Japanese Cities’ Detail

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

Solution
Select all columns and filter if CoutryCode equals 'JPN'.

I created solution in:

All solutions are also available on my GitHub.

SQL