Hackerrank - Japanese Cities Attributes solution

Solution one:

SELECT * FROM CITY WHERE COUNTRYCODE = "JPN";