For each date from 2025-01-01 to 2025-01-17 that appears in logins, return login_date and users_7d — distinct users who logged in during the 7 days ending on that date.
17 rows with columns login_date, users_7d — first 3 shown:
| # | ||
|---|---|---|
| 1 | 2025-01-01 | 3 |
| 2 | 2025-01-02 | 4 |
| 3 | 2025-01-03 | 4 |
Run your code to see the output here.