Mock interview. You're interviewing for a product analyst job on an app store team. The interviewer says: "The average star rating across the store has been sliding. Is something wrong with the store, or with some apps?" You have app_reviews (with the app_version each review was written on) and apps.
"Show the average rating for each month of 2026 and the change from the month before."
Expected output
avg_rating and change rounded to 2 decimals (change empty for January); sorted by monthExample of the shape (made-up values):
| month | reviews | avg_rating | change |
|---|---|---|---|
| 2026-01-01 | 100 | 4.50 | |
| 2026-02-01 | 120 | 4.30 | -0.20 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.