Im between cherry

Hackerrank | MySQL |Japanese Cities' Names 본문

데이터분석/practice_query

Hackerrank | MySQL |Japanese Cities' Names

meal 2020. 8. 27. 18:11

Japanese Cities' Names

Problem

 

Japanese Cities' Names | HackerRank

In this challenge, you will query a list of all the Japanese cities' names.

www.hackerrank.com

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:

 

 

Solution

SELECT NAME
FROM CITY
WHERE countrycode = 'JPN'

 

저작자표시 (새창열림)

'데이터분석 > practice_query' 카테고리의 다른 글

Hackerrank | MySQL | Weather Observation Station 3  (0) 2020.08.27
Hackerrank | MySQL | Weather Observation Station 1  (0) 2020.08.27
Hackerrank | MySQL | Japanese Cities' Attributes  (0) 2020.08.27
Hackerrank | MySQL | Select By ID  (0) 2020.08.27
Hackerrank | MySQL | Select All  (0) 2020.08.27
'데이터분석/practice_query' Related Articles more
Comments