Hackerrank Weather Observation Station 20 solution | Start-Tech Academy

Follow Start-Tech Academy on
Twitter: / starttechacade1
Facebook: / starttechacademy
Website: www.starttecha...
TH-cam Channel: / @starttechacademy

[@armangupta3428]

Correct my understanding. This query is selecting a lat_n value from the set such that there are an equal count of lat_n values that are lower than the selected value as there are lat_n values higher than the selected value. How would this work if the number of lat_n values are even? If the number of lat_n values were even, the median would not be a value in the set, it would be the mean of the 2 middle most values of the set.

[@talhanaeemrao4305]

it seems it is working by counting the rows where the number of rows > or < a number (which is median) get equal. but in case of even number of records, how will it work?

[@rajchandra6913]

2 values i guess then?

[@mr_possible6197]

Can this be considered efficient ? I am asking this because for every lat value, two selects will be run right ?

[@nimishjhawar7517]

Hi brother can you explain me in detail why you wrote your query in that way

[@rupadarshisamanta3288]

SELECT ROUND(median(LAT_N),4) AS median FROM STATION

[@jonathanremus5697]

Can you visualize the process of this code with smaller data sample? I can't visualize the subquery part.

[@aaaryaamse]

Is it logically correct if there are even number of records?

[@StartTechAcademy]

Yes is will be logically correct.

[@wedare4894]

NOt working in MYSQL

[@TrapRAM]

Its working, you just need to pay attention.