MySQL Solution


  • 1
    Y

    MySQL solution:

    #Write your MySQL query statement below
    
    select avg(number) as median from (
    select 
    number,frequency,
    @st_range:=@end_range+1 as st_range,
    @end_range:=@st_range+frequency-1 as end_range,
    c.total_sum
    from numbers a, (select @st_range:=0,@end_range:=0) b, (select sum(frequency) as total_sum from numbers )c
    order by number
    )a 
    where (floor((total_sum+1)/2)>=st_range and floor((total_sum+1)/2)<=end_range) or 
    (floor((total_sum+2)/2)>=st_range and floor((total_sum+2)/2)<=end_range) 
    ;
    

Log in to reply
 

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.