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 |