혜온의 이것저것

[HackerRank] Japanese Cities' Names (MySQL) 본문

Data Analysis/SQL

[HackerRank] Japanese Cities' Names (MySQL)

혜온 :) 2022. 8. 3. 11:19

https://www.hackerrank.com/challenges/japanese-cities-name/problem?isFullScreen=true 

 

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 Japan is JPN.
The CITY table is described as follows:

풀이
select name from city where countrycode = 'JPN'
저작자표시

'Data Analysis > SQL' 카테고리의 다른 글

[HackerRank] Weather Observation Station 3 (MySQL)  (0) 2022.08.03
[HackerRank] Weather Observation Station 1 (MySQL)  (0) 2022.08.03
[HackerRank] Japanese Cities' Attributes (MySQL)  (0) 2022.08.03
[HackerRank] Select By ID (MySQL)  (0) 2022.08.03
[HackerRank] Select All (MySQL)  (0) 2022.08.03
'Data Analysis/SQL' Related Articles more
Comments