[MySQL] HackerRank - Japanese Cities' Names

문제

https://www.hackerrank.com/challenges/japanese-cities-name/problem

Japanese Cities' Names | HackerRank

Query the names of all the Japanese cities in the CITY table. the COUNTRYCODE for Japanese is JPN. the CITY table is described as follows.

정답

SELECT NAME
FROM CITY
WHERE COUNTRYCODE LIKE 'JPN'