PayPal
Interview Core Track · Easy · 15 min
Churned Merchants with Pending Payouts
Risk ops needs a cleanup list for merchants who have already churned but still have money waiting to be disbursed. Return the merchant_id values for churned ...
Company labels are directional practice context, not official interview guidance.
Objective
Practice query basics through a PayPal-tagged business scenario.
Approach
Use this track to improve speed, edge-case handling, and accuracy under timed conditions.
Company context
Company labels are directional practice context, not official interview guidance.
Risk ops needs a cleanup list for merchants who have already churned but still have money waiting to be disbursed. Return the merchant_id values for churned merchants that have at least one payout_status of pending. Sort by merchant_id.
merchants
| merchant_id | merchant_status |
|---|---|
| 10 | active |
| 20 | churned |
| 30 | churned |
| 40 | active |
payouts
| payout_id | merchant_id | payout_status | |
|---|---|---|---|
| 1 | 10 | paid | 75.00 |
| 2 | 20 | pending | 120.00 |
| 3 | 20 | paid | 45.00 |
| 4 | 30 | pending | 65.00 |
| 5 | 40 | pending | 30.00 |
SQL workspace
Run queries against the protected question data, then submit once the result shape looks right.
Sign in to run SQL
Create a free account or sign in before running queries against protected question data.