Hackerrank - Japanese Cities Names solution

Problem link

Solution one:

SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN";