Bounced vs engaged sessions per device

Bounced vs engaged sessions per device

From the sessions table, for each device count two metrics: bounced_sessions — sessions with bounced = 1, and engaged_sessions — sessions with bounced = 0. Group by device and return columns device, bounced_sessions, engaged_sessions. Sort by device ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid