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.

Expected output sample

devicebounce_rate
desktop0.25
mobile0.5
tablet0.5
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid