문제
https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true
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';'SQL > HackerRank' 카테고리의 다른 글
| [MySQL] Weather Observation Station 5 (0) | 2023.01.26 |
|---|---|
| [MySQL] Weather Observation Station 4 (0) | 2023.01.26 |
| [MySQL] Weather Observation Station 3 (0) | 2023.01.26 |
| [MySQL] Weather Observation Station 1 (0) | 2023.01.26 |
| [MySQL] Japanese Cities' Attributes (0) | 2023.01.26 |
| [MySQL] Select By ID (0) | 2023.01.26 |
| [MySQL] Select All (0) | 2023.01.26 |
| [MySQL] Revising the Select Query II (0) | 2023.01.26 |