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 |