Mock interview. You're interviewing for a data analyst job on an app store team. The interviewer shares downloads and apps. "Two quick questions about the last quarter."
In downloads, is_redownload is true when the person had downloaded that app before (a new phone, or reinstalling). Those don't count as new downloads.
"For Q2 2026 (April to June): total downloads, first-time downloads, the number of different people who downloaded something, and the share of first-time downloads made on an iPhone."
Expected output
iphone_share as a percentage rounded to 1 decimalExample of the shape (made-up values):
| downloads | first_downloads | people | iphone_share |
|---|---|---|---|
| 4500 | 4000 | 2000 | 75.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.