[HackerRank SQL] Weather Observation Station 1 (Oracle)

Weather Observation Station 1

 

Problem

 

Query a list of CITY and STATE from the STATION table.

The STATION table is described as follows:

(STATION 테이블에서 CITY와 STATE를 조회하는 목록을 작성하시오. STATION 테이블은 다음과 같다:)

 

Solution(Oracle)

 

SELECT CITY, STATE FROM STATION
    ORDER BY CITY, STATE;

 

세미콜론(;) 작성을 까먹지 말자!

 

https://www.hackerrank.com/challenges/weather-observation-station-1/problem

Weather Observation Station 1 | HackerRank