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.

Exemplo de resposta esperada

devicebounced_sessionsengaged_sessions
desktop13
mobile22
tablet11
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid