Distinct countries per device

Distinct countries per device

From sessions(device, country), count the number of distinct countries per device. Output columns device and countries. Order by countries descending, then by device ascending.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid