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 |