Japanese City's Attributes query in SQL - Hacker Rank Solution

---

Problem :-

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

Input Format

The CITY table is described as follows:

---

Solution :-

 

SELECT * FROM CITY WHERE COUNTRYCODE = 'JPN';

the hole problem statement are given by HackerRank.com but the solution are generated by the codeworld19 authority if any of the query regarding this post or website fill the following contact form thank you.