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.

Expected output sample

devicebounced_sessionsengaged_sessions
desktop13
mobile22
tablet11
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid