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';




codesadda.com

Codesadda.com is your home of programming solutions, tutorials, video tutorials and much more. Sign Up for our weekly newsletter to get update about new content.

Like us on Facebook | Connect with us on LinkedIn | Subscribe our Channel on Youtube