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.

Exemplo de resposta esperada

devicecountries
mobile3
desktop2
tablet1
PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid