Unique Visitors per Day

Return each date with the number of distinct users who visited that day. Order by date.

Table schema

Visits(visit_date DATE, user_id INT)

Sample data

visit_date | user_id
2026-10-01 | 1
2026-10-01 | 1
2026-10-01 | 2
2026-10-02 | 1