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.

Row order matters

PostgreSQLv16

Your query result will appear here

Focus radio
Paused · SomaFM · Fluid