Mock interview. You're interviewing for a data analyst job on a visual discovery app's content team. People post pins (images or videos) and other people save them to their boards. The interviewer shares pins and saves and asks two questions.
"Look at pins created in Q2 2026 (April to June). How many were there, how many saves did they get in total, what's the average number of saves per pin, and what share got no saves at all?"
Expected output
avg_saves rounded to 2 decimals; pct_no_saves as a percentage rounded to 1 decimalExample of the shape (made-up values):
| pins | saves | avg_saves | pct_no_saves |
|---|---|---|---|
| 500 | 2000 | 4.00 | 10.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.