HackerRank MySQL - Japanese Cities' Names


Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

  1. SELECT NAME
  2. FROM CITY
  3. WHERE COUNTRYCODE = 'JPN';

download android app