Mock interview. You're interviewing for a data analyst job on a payments team. The interviewer shares transactions and merchants. Each payment has a status of completed, refunded or failed. "Let's look at the first quarter of 2026."
Payments are in different currencies, so this interview sticks to counts and rates, not money totals.
"For Q1 2026: payments, accounts that paid, and the completed, refunded and failed rates."
Expected output
Example of the shape (made-up values):
| payments | accounts | completed_rate | refunded_rate | failed_rate |
|---|---|---|---|---|
| 2000 | 350 | 85.0 | 9.0 | 6.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.