HackerRank-My SQL
Prepare > SQL > Basic Select > Japanese Cities' Attributes
stem_sw
2023. 7. 6. 19:09
Japanese Cities' Attributes | HackerRank
Query the attributes of all the cities in Japan.
www.hackerrank.com
문제
Query all attributes of every Japanese city in the CITY table. The COUNTRYCODE for Japan is JPN.
코드
SELECT * FROM CITY
WHERE COUNTRYCODE = 'JPN';