Hacker Rank SQL

Japanese Cities’ Names Solution

by Niyander

Hello Friends in this article i am gone to share Hacker Rank SQL Solutions with you | Japanese Cities’ Names Solution

Also visit this link:  Japanese Cities’ Attributes Solution

 

Problem

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

Field Type
ID NUMBER
NAME VARCHAR2(17)
COUNTRYCODE VARCHAR2(3)
DISTRICT VARCHAR2(20)
POPULATION NUMBER

 

Solution – Japanese Cities’ Names

MySQL Code
SELECT * FROM CITY WHERE COUNTRYCODE = "JPN";

 

All Japanese Cities’ Names 

  • Tokyo
  • Kyoto
  • Osaka
  • Fukuoka
  • Sapporo
  • Yokohama
  • Nagoya
  • Kobe
  • Hiroshima
  • Nagasaki
  • Sendai
  • Nara
  • Kanazawa
  • Kagoshima
  • Saitama
  • Aomori
  • Shizuoka
  • Chiba
  • Naha
  • Nagano
  • Kumamoto
  • Okayama
  • Fukushima
  • Akita

 

What is Japan No 1 in?

The country is among the world’s largest producers of motor vehicles, electronic equipment and steel. The service sector makes up the highest percentage of the economy in terms of gross domestic product and. Japan is known worldwide for its traditional arts, including tea ceremonies, calligraphy and flower arranging.

What food is popular in Japan?

Must-try Japanese foods – Japan Centre

  • Sushi. Sushi is one of the first foods that spring to mind when we think about Japanese cuisine.
  • Udon
  • Tofu
  • Tempura
  • Yakitori
  • Sashimi
  • Ramen
  • Donburi

 

Disclaimer: The above Problems are generated by Hacker Rank but the Solutions are Provided by NYANDER.COM. All Hacker Rank SQL Solutions Shared only for Educational and Learning Purpose.