SELECT value_pause_duration, c_sum, total_views FROM(
SELECT value_pause_duration, weight_view_count, SUM(weight_view_count) OVER (ORDER BY value_pause_duration) AS c_sum, SUM(weight_view_count) OVER () as total_views
FROM zareen.testing
ORDER BY value_pause_duration
LIMIT 10) as inner
WHERE c_sum >= int(total_views/2)
LIMIT 1;