Lim Seunghyun Space

[HackerRank] Japanese Cities' Names 본문

SQL/SQL 문제

[HackerRank] Japanese Cities' Names

Lim Seung Hyun 2021. 11. 19. 10:19

문제 : 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

 

문제 해설

  • CITY 테이블에서 Japanese cities 조회를 위해 COUNTRYCODE가 JPN 데이터를 조회
  • OUTPUT 조건은 NAME만 조회

 

풀이 (MySQL)

SELECT NAME
FROM CITY
WHERE COUNTRYCODE = "JPN";
728x90

'SQL > SQL 문제' 카테고리의 다른 글

[HackerRank] Weather Observation Station 3  (0) 2021.11.19
[HackerRank] Weather Observation Station 1  (0) 2021.11.19
[HackerRank] Japanese Cities' Attributes  (0) 2021.11.19
[HackerRank] Select By ID  (0) 2021.11.19
[HackerRank] Select All  (0) 2021.11.19
'SQL/SQL 문제' Related Articles more