๋ฐ์ํ
๋ฌธ์
https://www.hackerrank.com/challenges/japanese-cities-name/problem
Query the names of all the Japanese cities in the CITY table. the COUNTRYCODE for Japanese is JPN. the CITY table is described as follows.
์ ๋ต
SELECT NAME
FROM CITY
WHERE COUNTRYCODE LIKE 'JPN'
๋ฐ์ํ
'Algorithm > SQL Query test' ์นดํ ๊ณ ๋ฆฌ์ ๋ค๋ฅธ ๊ธ
[MySQL] HackerRank - Weather Observation Station 3 (0) | 2021.07.20 |
---|---|
[MySQL] HackerRank - Weather Observation Station 1 (0) | 2021.07.20 |
[MySQL] HackerRank - Japanese Cities' Attributes (0) | 2021.07.20 |
[MySQL] HackerRank - Select By ID (0) | 2021.07.20 |
[MySQL] HackerRank - Select All (0) | 2021.07.20 |