Im between cherry

Hackerrank | MySQL | Japanese Cities' Attributes 본문

데이터분석/practice_query

Hackerrank | MySQL | Japanese Cities' Attributes

meal 2020. 8. 27. 18:02

Japanese Cities' Attributes

Problem

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

The CITY table is described as follows:

 

Japanese Cities' Attributes | HackerRank

Query the attributes of all the cities in Japan.

www.hackerrank.com

Solution

SELECT *
FROM CITY
WHERE countrycode = 'JPN'
저작자표시 (새창열림)

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

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