Your question is Use Window Functions. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Credit Karma’s Product Analytics team wants to monitor daily engagement with Credit Karma Credit Score. Write a PostgreSQL query that calculates the number of distinct active members viewing their score each day and a 3-day rolling average by state.
members to score_views using member_id.credit_score from January 1 through January 3, 2026.| Column | Type | Description |
|---|---|---|
| member_idPK | INT | Unique Credit Karma member identifier |
| state | VARCHAR(2) | Two-letter member state code |
| membership_status | VARCHAR(20) | Current membership status |
| Column | Type | Description |
|---|---|---|
| view_idPK | INT | Unique score-view event identifier |
| member_id | INT | Member associated with the event |
| viewed_at | DATE | Date on which the feature was viewed |
| event_type | VARCHAR(30) | Product or feature viewed |