11 SQL practice questions in our Stripe collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
4 Medium · 3 Medium–Hard · 4 Hard
Independent practice resource. Not affiliated with or endorsed by Stripe.
These topics come from the questions in this set. Pick one to open the matching problems.
Identify the top 5 highest-earning employees by total compensation (salary + bonuses) in the last 12 months. Rank them within their department and compare to the department average. Return employee_id, name, department, total_compensation, dept_rank, dept_avg, vs_dept_avg.
Identify duplicate/repeated payments within the same customer account in a 5-minute window. A duplicate is same customer, same amount, same currency. Flag each payment as 'original' or 'duplicate' and track its occurrence number. Return payment_id, customer_id, amount, currency, created_at, payment_type, occurrence_number.
For each merchant and day, calculate the rolling 3-day sum of earnings and the rolling average of the previous 7 days (excluding the current day). Flag any day where the daily total dropped 50%+ from the 7-day rolling average. Return transaction_date, merchant_id, merchant_name, category, daily_total, rolling_3day_sum, rolling_7day_avg_prior, large_drop_flag.
11 Stripe problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
Your dataset
employee_id (INT) · name (VARCHAR) · department (VARCHAR) · salary (DECIMAL) · hire_date (DATE)
payment_id (INT) · employee_id (INT) · bonus_amount (DECIMAL) · payment_date (DATE)
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice Stripe SQL free188 SQL practice questions. 23 companies. Free access to every problem.