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.

A ordem das linhas importa

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid