HomeFind Median Given Frequency of NumbersRead 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))
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))