Is there a difference in the user experience between different devices?
For example, what is the median session duration in minutes, breakdown by user device?
SELECT avg(median) AS median_session_duration_mins, session_os
FROM
(SELECT percentile_cont(0.5) OVER (PARTITION BY session_os ORDER BY p_duration) AS median, session_os
FROM
(SELECT path_duration() /1000/60 AS p_duration, session_os
FROM cooladata
WHERE date_range (doc.date_range)
) )
GROUP BY session_os