Getting DISTINCT IDs for DISTINCT Dates in BigQuery Using Date Trunc and Group By

Counting Unique IDs Within a Moving Time Window in Oracle SQL Using MATCH_RECOGNIZE

Counting Distinct IDs for Each Day within the Last 7 Days using SQL