Stripe 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.
Stripe
Explore 7 Stripe-tagged SQL scenarios focused on query basics, aggregation, date functions.
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
7
Estimated prep time
145 min
Progress tracking
Sign in to track progress
Concept focus
The most common patterns in the current Stripe-tagged set.
Query basics
7
Aggregation
2
Date functions
2
Filtering
1
Joins
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.
Top Sellers By Gross Sales
Practice query basics through a Stripe-tagged business scenario.
2024 App Click Volume
Practice query basics through a Stripe-tagged business scenario.
Pages With No Likes
Practice query basics through a Stripe-tagged business scenario.
Question list
The current Stripe-tagged list with learning objectives and your latest status.
Top Sellers By Gross Sales
Stripe is reviewing top sellers by gross sales through a operations review. Return the top 3 sellers by total_gross_sales. Output seller_id and total_gross_s...
Practice query basics through a Stripe-tagged business scenario.
2024 App Click Volume
At Stripe, analysts are preparing a ops memo focused on 2024 app click volume. Return each app_id and the total number of click events recorded in 2024. Sort...
Practice query basics through a Stripe-tagged business scenario.
Pages With No Likes
Use this Stripe operations review to work on pages with no likes. Return every page_id that has no follower rows. Sort by page_id.
Practice query basics through a Stripe-tagged business scenario.
Creators With Multiple 2024 Posts
At Stripe, analysts are preparing a coverage check focused on creators with multiple 2024 posts. Return each creator_id that posted at least two items in 202...
Practice query basics through a Stripe-tagged business scenario.
Average Minutes to First Reply
Support leadership wants to compare response speed across inboxes. For conversations created in May 2024, return each inbox_name and the average number of mi...
Practice query basics through a Stripe-tagged business scenario.
Departments Above Average Pay
Stripe is reviewing departments above average pay through a readout. Return each department_id whose average salary exceeds the company average salary for Ma...
Practice query basics through a Stripe-tagged business scenario.
Rapid Repeat Card Payments
Risk operations wants to flag merchants that received back-to-back payments for the same amount within a ten-minute window. For each merchant_id, return repe...
Practice query basics through a Stripe-tagged business scenario.