Milky's note

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

SQL/SQL 코딩 테스트-HackerRank

[HackerRank](E) Japanese Cities' Attributes

밀뿌 2022. 3. 16. 14:25

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:

 

[답]

- oracle

select * from city
where countrycode = 'JPN';

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

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