Leetcode/database/_571.sql at master · fishercoder1534/Leetcode · GitHub

Name: Leetcode/database/_571.sql at master · fishercoder1534/Leetcode · GitHub
Rating: 4.5 (991 reviews)
1
2
3
4
5
6
7
8
9
10
11
12
select FORMAT(avg(n.Number),4)*1.0as median
from Numbers n left join
(
selectNumber, @prev := @count as prevNumber, (@count := @count + Frequency) as countNumber
from Numbers,
(select @count :=0, @prev :=0, @total := (selectsum(Frequency) from Numbers)) temp order byNumber
) n2
onn.Number=n2.Number
where
(prevNumber < floor((@total+1)/2) and countNumber >= floor((@total+1)/2))
or
(prevNumber < floor((@total+2)/2) and countNumber >= floor((@total+2)/2))