HackerRank MySQL - Japanese Cities' Attributes




Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.



  1. SELECT *
  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