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.
Expected output sample
| device | countries |
|---|---|
| mobile | 3 |
| desktop | 2 |
| tablet | 1 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid