Hackerrank - Japanese Cities Attributes solution

Problem link

Solution one:

SELECT * FROM CITY WHERE COUNTRYCODE = "JPN";