[HackerRank] Weather Observation Station 1 SQL

@notepad_jj2

츄르사려고 코딩하는집사입니다.

---

1. [HackerRank] Weather Observation Station 1 SQL

 

2. 문제 출처

https://www.hackerrank.com/challenges/weather-observation-station-1/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen 

Weather Observation Station 1 | HackerRank

 

3. 문제

Query a list of CITY and STATE from the STATION table.
The STATION table is described as follows:

where LAT_N is the northern latitude and LONG_W is the western longitude.

4. 소스 코드

SELECT CITY, STATE
FROM STATION;

 

---