HACKER RANK : SQL–5.Japanese Cities’ Attributes

Difficulty: Easy

5. Japanese Cities’ Attributes

Table: The CITY table is described as follows:

Table : CITY

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

Solution:

# Write your MySQL query statement below

(Check Out Git Hub-https://github.com/poulamicode77/SQL/tree/main/HackerRank/Solve%20SQL/5.Japanese%20Cities'%20Attributes)

Query Breakdown:

select all column : select * from
source table name : city
condition is country is Japan :WHERE countrycode = “JPN”;