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 |