Potato
์•ˆ๋…•ํ•˜์„ธ์š”, ๊ฐ์žก๋‹ˆ๋‹ค?๐Ÿฅ” ^___^ ๐Ÿ˜บ github ๋ฐ”๋กœ๊ฐ€๊ธฐ ๐Ÿ‘‰๐Ÿป

Algorithm/SQL Query test

[MySQL] HackerRank - Weather Observation Station 1

๊ฐ์ž ๐Ÿฅ” 2021. 7. 20. 02:51
๋ฐ˜์‘ํ˜•

๋ฌธ์ œ

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

 

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

๋ฐ˜์‘ํ˜•

'Algorithm > SQL Query test' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

[MySQL] HackerRank - Weather Observation Station 4  (0) 2021.07.20
[MySQL] HackerRank - Weather Observation Station 3  (0) 2021.07.20
[MySQL] HackerRank - Japanese Cities' Names  (0) 2021.07.20
[MySQL] HackerRank - Japanese Cities' Attributes  (0) 2021.07.20
[MySQL] HackerRank - Select By ID  (0) 2021.07.20