Query the names of all the Japanese cities in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
조건이 이번엔 모든 컬럼이 아닌, 이름만 가져오라 했으니까
SELECT NAME
FROM CITY
WHERE COUNTRYCODE = 'JPN' ;
Japanese Cities' Names | HackerRank
Japanese Cities' Names | HackerRank
In this challenge, you will query a list of all the Japanese cities' names.
www.hackerrank.com
'문제풀이 > HackerRank' 카테고리의 다른 글
| Weather Observation Station 3 (0) | 2022.11.02 |
|---|---|
| Weather Observation Station 1 (0) | 2022.11.02 |
| Japanese Cities' Attributes (0) | 2022.11.02 |
| Select By ID (0) | 2022.11.02 |
| Select All (0) | 2022.11.02 |
