Mock interview. You're interviewing for a product analyst job on a jobs marketplace team. The interviewer says: "Someone in a meeting said job views dipped in May. Can you check, and if it's real, tell us why and what it cost?" You have job_views, where source says how the member got to the job: search, recommended, email_alert or feed.
"Show total job views per week from the week of 13 April to the end of May, with the percentage change from the week before."
Expected output
pct_change rounded to 1 decimal, empty for the first week; sorted by week_startExample of the shape (made-up values):
| week_start | views | pct_change |
|---|---|---|
| 2026-04-13 | 400 | |
| 2026-04-20 | 440 | 10.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.