728x90
반응형
https://www.hackerrank.com/challenges/japanese-cities-attributes/problem?isFullScreen=true
Japanese Cities' Attributes | HackerRank
Query the attributes of all the cities in Japan.
www.hackerrank.com
문제
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
The CITY table is described as follows:
Code
SELECT *
FROM CITY
WHERE COUNTRYCODE = 'JPN';
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Weather Observation Station 1 (0) | 2023.08.12 |
---|---|
[MySQL/HackerRank] Japanese Cities' Names (0) | 2023.08.12 |
[MySQL/HackerRank] Select By ID (0) | 2023.08.12 |
[MySQL/HackerRank] Select All (0) | 2023.08.12 |
[MySQL/HackerRank] Revising the Select Query II (0) | 2023.08.12 |