Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:

SELECT
*
FROM
CITY
WHERE
COUNTRYCODE = "JPN"

'SQL > HackerRank' 카테고리의 다른 글
| [MySQL/HackerRank] Weather Observation Station 3 (0) | 2024.08.11 |
|---|---|
| [MySQL/HackerRank] Weather Observation Station 1 (0) | 2024.08.11 |
| [MySQL/HackerRank] Select By ID (0) | 2024.08.11 |
| [MySQL/HackerRank] Select All (0) | 2024.08.11 |
| [MySQL/HackerRank] Revising the Select Query II (0) | 2024.08.11 |