Milky's note

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

SQL/SQL 코딩 테스트-HackerRank

[HackerRank](E) Weather Observation Station 16

밀뿌 2022. 3. 25. 17:46

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

 

Weather Observation Station 16 | HackerRank

Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places

www.hackerrank.com

 

[문제]

Query the smallest Northern Latitude (LAT_N) from STATION that is greater than 38.7780. Round your answer to  decimal places.

Input Format

The STATION table is described as follows:

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

 

 

[답]

- mysql

select round(min(lat_n),4) from station
where lat_n > 38.7780

'SQL > SQL 코딩 테스트-HackerRank' 카테고리의 다른 글

[HackerRank](E) Population Census  (0) 2022.03.25
[HackerRank](E) Weather Observation Station 17  (0) 2022.03.25
[HackerRank](E) Weather Observation Station 15  (0) 2022.03.25
[HackerRank](E) Weather Observation Station 14  (0) 2022.03.25
[HackerRank](E) Weather Observation Station 13  (0) 2022.03.25
'SQL/SQL 코딩 테스트-HackerRank' Related Articles more
Comments