[HackerRank] Japanese Cities' Attributes

2021. 1. 20. 20:39데이터베이스/SQL

728x90
반응형

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';

'데이터베이스 > SQL' 카테고리의 다른 글

[HackerRank] Weather Observation Station 3  (0) 2021.01.20
[HackerRank] Weather Observation Station 1  (0) 2021.01.20
[HackerRank] Japanese Cities' Names  (0) 2021.01.19
[HackerRank] Select By ID  (0) 2021.01.19
[HackerRank] Select All  (0) 2021.01.19