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

❓ Question

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

Japanese Cities' Names | HackerRank

❗ Answer

SELECT name
    FROM city
    WHERE countrycode = 'JPN';

📌 Discussion

- SELECT 문에서 name 컬럼만 추출