Median and average duration by device
Median and average duration by device
From the sessions table, for each device compute the median of duration_sec (median_duration) and the average duration rounded to 2 decimals (avg_duration). Return device, median_duration, avg_duration ordered by device ascending.
Exemplo de resposta esperada
| device | median_duration | avg_duration |
|---|---|---|
| desktop | 200 | 136.25 |
| mobile | 90 | 62.5 |
| tablet | 300 | 157.5 |
Entre para ver seu histórico de envios
EntrarEntre para usar o AI Mentor
EntrarFocus radio
Paused · SomaFM · Fluid