Find Median Given Frequency of Numbers

Read top solution.

1
2
3
4
select  round(avg(n.Num),1) median
from Numbers n
where n.Frequency >= abs((select sum(Frequency) from Numbers where Num<=n.Num) -
                         (select sum(Frequency) from Numbers where Num>=n.Num))