~고군분투 인생살이~

[EASY] Japanese Cities' Attributes 본문

SQL/HACKER_RANK

[EASY] Japanese Cities' Attributes

소금깨 2022. 10. 13. 21:13

 

 

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.

 

정답 쿼리

select *
from city
where countrycode = 'JPN'

 

저작자표시

'SQL > HACKER_RANK' 카테고리의 다른 글

[MEDIUN] New Companies  (0) 2022.10.13
[EASY] Japanese Cities' Names  (0) 2022.10.13
[EASY] Select By ID  (0) 2022.10.13
[MEDIUM] Binary Tree Nodes  (0) 2022.10.12
[MEDIUM] The PADS  (0) 2022.10.12
'SQL/HACKER_RANK' Related Articles more
Comments