Bounce rate per device

Bounce rate per device

From the sessions table, compute each device's bounce rate: the ratio of sessions with bounced = 1 to the total number of sessions. Group by device, round the ratio to 4 decimals, and return columns device and bounce_rate. Sort by device ascending. The count() denominator is always > 0 within a group.

Exemplo de resposta esperada

devicebounce_rate
desktop0.25
mobile0.5
tablet0.5
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid