Milky's note

[HackerRank](E) Weather Observation Station 1 본문

SQL/SQL 코딩 테스트-HackerRank

[HackerRank](E) Weather Observation Station 1

밀뿌 2022. 3. 16. 14:29

https://www.hackerrank.com/challenges/weather-observation-station-1/problem?isFullScreen=true 

 

Weather Observation Station 1 | HackerRank

Write a query to print the CITY and STATE for each attribute in the STATION table.

www.hackerrank.com

 

[문제]

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.

 

[답]

- oracle

select city, state from station;
Comments