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:
[MY Answer]
select name from city
where countrycode = 'JPN'
I told you that I will write English only on this blog,,,
As you know, my English is not that fluent yet, cuz I forgot all my vocab and sense of writing English...
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
[HackerRank] Weather Observation Station 3 (0) | 2021.04.08 |
---|---|
[HackerRanker] Weather Observation Station 1 (0) | 2021.04.08 |
[HackerRank]Select By ID (0) | 2021.04.08 |
[HackerRank]Revising the Select Query II (0) | 2021.03.30 |
[HackerRank] Revising the Select Query I (0) | 2021.03.29 |