혜온의 이것저것

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

Data Analysis/SQL

[HackerRank] Japanese Cities' Attributes (MySQL)

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

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

 

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.

The CITY table is described as follows:

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

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

[HackerRank] Weather Observation Station 1 (MySQL)  (0) 2022.08.03
[HackerRank] Japanese Cities' Names (MySQL)  (0) 2022.08.03
[HackerRank] Select By ID (MySQL)  (0) 2022.08.03
[HackerRank] Select All (MySQL)  (0) 2022.08.03
[HackerRank] Revising the Select Query II (MySQL)  (0) 2022.08.03
'Data Analysis/SQL' Related Articles more
Comments