SQL 문제풀이

[해커랭크 SQL] Basic Select - Japanese Cities' Names

냄비짱 2023. 8. 16. 00:09
728x90

❓ Question

https://www.hackerrank.com/challenges/japanese-cities-name 

 

Japanese Cities' Names | HackerRank

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

www.hackerrank.com

❗ Answer

SELECT name
    FROM city
    WHERE countrycode = 'JPN';

📌 Discussion

- SELECT 문에서 name 컬럼만 추출