Japanese Cities’ Names
- URL : https://www.hackerrank.com/challenges/japanese-cities-name/problem
- Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
- MySQL, Oracle Solution
1
2
3
select name
from city
where countrycode = 'JPN';