본문 바로가기
DB/SQL

HackerRank_06. Japanese Cities' Names

by _S0_H2_ 2020. 6. 11.
728x90
반응형

문제 : Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.

 

select NAME
from CITY
where COUNTRYCODE = 'JPN';

Neyagawa

Ageo

Sayama

Omuta

Tokuyama

728x90
반응형

'DB > SQL' 카테고리의 다른 글

HackerRank_08. Weather Observation Station 2  (0) 2020.06.11
HackerRank_07.Weather Observation Station 1  (0) 2020.06.11
HackerRank_05.Japanese Cities' Attributes  (0) 2020.06.11
HackerRank_04. Select By ID  (0) 2020.06.11
HackerRank_03. SELECT ALL  (0) 2020.06.11