Mock interview. You're interviewing for a merchandising analyst job at a large retailer. The interviewer says: "Revenue has been soft since spring. Leadership wants to know where it's coming from, and whether shoppers just moved online."
Revenue of a line is units * unit_price. The channel is in_store, pickup (ordered online, collected at the store) or delivery.
"Show revenue for each month of 2026 and the percentage change from the month before."
Expected output
pct_change rounded to 1 decimal, empty for January; sorted by monthExample of the shape (made-up values):
| month | revenue | pct_change |
|---|---|---|
| 2026-01-01 | 40000.00 | |
| 2026-02-01 | 42000.00 | 5.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.