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
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid