Milky's note

[HackerRank](E) Japanese Cities' Names 본문

SQL/SQL 코딩 테스트-HackerRank

[HackerRank](E) Japanese Cities' Names

밀뿌 2022. 3. 16. 14:27

https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true 

 

Japanese Cities' Names | HackerRank

In this challenge, you will query a list of all the Japanese cities' names.

www.hackerrank.com

 

[문제]

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:

 

[답]

- oracle

select name from city
where countrycode = 'JPN';

 

'SQL > SQL 코딩 테스트-HackerRank' 카테고리의 다른 글

[HackerRank](E) Weather Observation Station 3  (0) 2022.03.16
[HackerRank](E) Weather Observation Station 1  (0) 2022.03.16
[HackerRank](E) Japanese Cities' Attributes  (0) 2022.03.16
[HackerRank](E) Select By ID  (0) 2022.03.16
[HackerRank](E) Select All  (0) 2022.03.16
'SQL/SQL 코딩 테스트-HackerRank' Related Articles more
Comments