Potato
์•ˆ๋…•ํ•˜์„ธ์š”, ๊ฐ์žก๋‹ˆ๋‹ค?๐Ÿฅ” ^___^ ๐Ÿ˜บ github ๋ฐ”๋กœ๊ฐ€๊ธฐ ๐Ÿ‘‰๐Ÿป

Algorithm/SQL Query test

[MySQL] HackerRank - Japanese Cities' Names

๊ฐ์ž ๐Ÿฅ” 2021. 7. 20. 02:45
๋ฐ˜์‘ํ˜•

๋ฌธ์ œ

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

 

Japanese Cities' Names | HackerRank

In this challenge, you will query a list of all the Japanese cities' names.

www.hackerrank.com

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