HackerRank MySQL - Japanese Cities' Attributes
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
- SELECT *
- FROM CITY
- WHERE COUNTRYCODE = 'JPN';
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
- SELECT *
- FROM CITY
- WHERE COUNTRYCODE = 'JPN';