Sessions per device

Sessions per device

From the sessions table, count how many sessions each device has. Group by device and return columns device and sessions (the row count of sessions). Sort by device ascending.

Exemplo de resposta esperada

devicesessions
desktop4
mobile4
tablet2
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid