SQL: 7-day rolling active users
Medium · Whiteboard
Table events(user_id, event_time). Write a query that returns each day and the 7-day rolling average of daily active users. Write it on the board and talk through it.
Create a free account to answer it and get scored on what a strong answer covers.