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.

Expected output sample

devicesessions
desktop4
mobile4
tablet2
PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid