[MySQL] HackerRank - Japanese Cities' Attributes

문제

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

Japanese Cities' Attributes | HackerRank

Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japanese is JPN. The CITY table is described as follows.

정답

SELECT *
FROM CITY
WHERE COUNTRYCODE LIKE 'JPN'

 

아직은 너무 간단하지만... 그래도 TOSS 쿼리테스트 합격을 기원하며 허ㅓ히허ㅣ허ㅣㅎ ㅣ제발..!🙏