Japanese Cities’ Attributes
- URL : https://www.hackerrank.com/challenges/japanese-cities-attributes/problem
- Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
- MySQL, Oracle Solution
1
2
3
SELECT *
FROM city
WHERE countrycode = 'JPN';