Cumulative Distinct Users
Hard
Query Patterns
For each day return the number of distinct users seen up to and including that day. Order by day.
Table schema
Visits(day INT, user_id INT)Sample data
day | user_id
1 | 1
1 | 2
2 | 2
2 | 3
3 | 1
Discussion
No discussions yet.
Shalyam Support
Hi! Ask us anything — we'll reply on WhatsApp or Telegram within 24 hours.