본문 바로가기
DB/SQL

HackerRank_05.Japanese Cities' Attributes

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

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

select *
from CITY
where COUNTRYCODE = 'JPN';

1613 Neyagawa JPN Osaka 257315

1630 Ageo JPN Saitama 209442

1661 Sayama JPN Saitama 162472

1681 Omuta JPN Fukuoka 142889

1739 Tokuyama JPN Yamaguchi 107078

728x90
반응형

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

HackerRank_07.Weather Observation Station 1  (0) 2020.06.11
HackerRank_06. Japanese Cities' Names  (0) 2020.06.11
HackerRank_04. Select By ID  (0) 2020.06.11
HackerRank_03. SELECT ALL  (0) 2020.06.11
HackerRank_02. Revising the Select Query II  (0) 2020.06.11