Number of distinct pages per user

Number of distinct pages per user

From sessions(user_id, page), count the number of distinct pages each user_id visited. Output columns user_id and distinct_pages. Order by distinct_pages descending, then by user_id ascending.

A ordem das linhas importa

PostgreSQLv16
Entre para enviar

O resultado da sua consulta aparecerá aqui

Focus radio
Paused · SomaFM · Fluid