PayPal practice guide
Stay inside one business context for a few reps in a row while still working from the same live bank used across practice, tracks, and reviews.
PayPal
Explore 5 PayPal-tagged SQL scenarios focused on query basics, aggregation, filtering.
Context, not signal
Company labels help frame practice in a familiar business context. They are directional study aids, not official interview guidance from the companies listed.
Sign in to track progress while you browse this guide.
Questions
5
Estimated prep time
95 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current PayPal-tagged set.
Query basics
4
Aggregation
3
Filtering
2
Joins
2
Analytics reporting
1
Date functions
1
Mix at a glance
Use the difficulty and path mix to decide whether you want fundamentals, breadth, or stretch reps.
Suggested rhythm
Start with the easiest scenario in the set, then move upward while tracking accuracy and retry speed. This keeps the context stable while the difficulty rises.
Suggested next scenarios
The next best reps from this company-tagged set based on what you have not solved yet.
Churned Merchants with Pending Payouts
Practice query basics through a PayPal-tagged business scenario.
Final Wallet Balance
Practice query basics through a PayPal-tagged business scenario.
9. Filter PayPal Customer Records Based on Email Domain
Practice filtering through a PayPal-tagged business scenario.
Question list
The current PayPal-tagged list with learning objectives and your latest status.
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 ...
Practice query basics through a PayPal-tagged business scenario.
Final Wallet Balance
For each account_id, calculate the final wallet balance. Credits add to the balance and debits subtract from it. Return account_id and final_balance ordered ...
Practice query basics through a PayPal-tagged business scenario.
9. Filter PayPal Customer Records Based on Email Domain
As a PayPal data analyst, you are tasked with identifying user profiles that were created with corporate email addresses, specifically those that end with '@...
Practice filtering through a PayPal-tagged business scenario.
First Purchase Revenue by Signup Month
Revenue planning wants to understand how much first-time purchase revenue is coming from each merchant signup cohort. Return signup_month and the total value...
Practice query basics through a PayPal-tagged business scenario.
Bidirectional Transfer Pairs
Finance operations wants to count how many unique user-to-user transfer relationships exist in the ledger. Transfers between the same two users should count ...
Practice query basics through a PayPal-tagged business scenario.