SQL 문제 43 - Weather Observation Station 20(HackerRank)

SQL 문제 43 - Weather Observation Station 20(HackerRank)

SQL 문제 43 - Weather Observation Station 20(HackerRank) Weather Observation Station 20 풀이 SELECT ROUND(S1.LAT_N,4) AS MEDIAN FROM STATION S1 WHERE (SELECT COUNT(LAT_N) FROM STATION WHERE LAT_N < S1.LAT_N) = (SELECT COUNT(LAT_N) FROM STATION WHERE LAT_N > S1.LAT_N); - 중간부분을 찾아서 푸는 문제이다. * 출처 Top Earners | HackerRank Find the maximum amount of money earned by any employee, as well as the number of top earners (people who have earned this amount). www.hackerrank.com...

#HackerRank #SQL #SQL_HackerRank #SQL_WeatherObservationStation20 #SQL_WeatherObservationStation20_HackerRank #WeatherObservationStation20 #WeatherObservationStation20_HackerRank

원문링크 : SQL 문제 43 - Weather Observation Station 20(HackerRank)

 등록된 다른 글

Python HackerRank 문제 27 - itertools.permutations()

SQL 문제 14 - Employees With Missing Information LeetCode 1965

SQL 문제 28 - Find Total Time Spent by Each Employee LeetCode 1741

JavaScript_코딩 기초 트레이닝_수 조작하기 1_school_programmers

SQL(MySQL/MariaDB) - Auto Increment