[SQL] Need an help in finding a median in mysql

I have a table like Table name as Duration



Now we need to get the distinct local_hour, local_end_day, count of each local_hour and median of duration each hour.

I tried to with this

select distinct local_hour, local_end_day, count(*) , TOP 1 PERCENTILE_CONT (0.5)
WITHIN GROUP (ORDER BY DURATION asc)
OVER () AS MEDIAN as FROM Duration

Continue reading...