혜온의 이것저것

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

Data Analysis/SQL

[HackerRank] Weather Observation Station 1 (MySQL)

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

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.

 

풀이
select city, state from station
Comments