SQL 문제풀이

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

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

❓ Question

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

 

Japanese Cities' Attributes | HackerRank

Query the attributes of all the cities in Japan.

www.hackerrank.com

❗ Answer

SELECT *
    FROM city
    WHERE countrycode = 'JPN';

📌 Discussion

- WHERE 절에서 조건문으로 필터링