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 |