caseSQL vs StrataScratch: Narrative missions vs question volume
Question-bank platforms give you depth of volume. caseSQL gives you a 25-mission analyst arc inside a simulated company. Pick the one that matches how you actually learn.
If you’re comparing caseSQL to StrataScratch or other SQL interview question banks, the distinction is breadth vs. narrative. Question banks’ strength is breadth — a large catalog of interview questions sourced from real companies, with datasets you can drill against repeatedly. caseSQL’s strength is narrative — each path is 25 connected missions set inside one simulated analyst role, with briefs written by “stakeholders” and graduated manager-style feedback. If you learn best by drilling volume, lean question-bank. If you learn best by doing the job, lean caseSQL.
Three ways caseSQL is different
caseSQL differs from SQL interview question banks in three ways.
01Narrative missions, not standalone problems
A caseSQL path is a story. You start as a new hire, the first brief is from a PM who wants last quarter’s top campaigns, and by mission 15 you’re building cohort retention reports for the VP. Context carries across missions — the same tables, the same stakeholders, the same vocabulary. Question-bank platforms are structured to let you dip in and out of unrelated problems, which is great for breadth and less great for building the mental model of a real job.
025-tier manager feedback vs pass/fail
Submit a correct-but-messy query on caseSQL and you’ll get “directionally right, but your numbers are off by the cancelled orders — want to rethink the filter?” rather than a red X. The validator grades on five tiers (wrong shape, wrong values, partially right, right-with-caveats, fully right) and the UI renders each tier as a Slack-style reply. That feedback loop is where most of the actual learning happens.
03Industry-first paths, not company-first questions
caseSQL’s eight paths are organized by industry — Marketing, BI, Provider, Finance, Credit Risk & Banking, AML & Fraud, RevOps, and Ecommerce. Each path has its own database, its own domain vocabulary, and its own KPIs. Question-bank platforms are typically organized company-first (“problems from Airbnb, problems from Meta”). Both are valid axes; caseSQL’s bet is that the industry axis transfers better into your first 90 days on the job.
Feature comparison
“Not a focus” means it isn't what that platform optimizes for — it's not an assertion that the feature is unavailable.
Feature
caseSQL
Question bank
Browser-based SQL editor, no local setup
Yes
Yes
Narrative mission arcs with stakeholder briefs
Yes
Not a focus
5-tier graduated validator
Yes
Not a focus
Industry-organized career paths
Yes
Partial
Intentionally dirty data (NULLs, dupes, refunds)
Yes
Partial
Progressive hint system with XP cost
Yes
Partial
Large real-company interview question bank
Partial
Yes
Data-project / take-home practice sets
Partial
Yes
Free tier + paid Pro ($14.99/mo or $139/yr)
Yes
Partial
Which one should you pick?
Not every reader should pick caseSQL. Honest summary:
Pick caseSQL if…
•You want an analyst arc, not a question feed.
•Domain fluency (marketing, BI, provider-side healthcare, finance) matters as much to you as SQL mechanics.
•You value graduated feedback over a binary right/wrong.
•Gamified progression (XP, streaks, paths) keeps you consistent.
Pick a question-bank platform if…
•You want the largest possible catalog of real-company interview questions.
•You’re drilling for a specific company’s take-home or onsite.
•Question volume is your primary selection criterion.
Frequently asked questions
Is caseSQL a good StrataScratch alternative?
They overlap but optimize for different things. StrataScratch and similar question banks give you breadth — a big catalog of real-company questions you can drill against. caseSQL gives you depth and narrative — a 25-mission analyst arc per industry with manager-style feedback. It’s reasonable to use both.
How many problems does caseSQL have?
Eight paths, 241 missions total today (Marketing, Provider, Finance, Banking, AML, RevOps, Ecommerce at 30 each; Business Intelligence at 31 with the grain-reasoning capstone), with more paths in the pipeline. We’re deliberately shipping fewer, denser missions rather than thousands of drills — each one has a brief, a scorecard, and a debrief.
Do you have company-specific practice (Amazon, Meta, etc.)?
Partially. Career-path missions are set inside simulated companies (an e-commerce retailer, a hospital system, a fintech) because the point is to simulate the job, not the onsite. The separate coding interview bank does tag questions with the real companies they came from (Stripe, Meta, Amazon, and more) and is included with Pro.
How does the free tier compare to Pro?
Free covers the Starter and Easy missions on every career path (10 per path) plus 12 coding interview questions. Pro ($14.99/month or $139/year) unlocks the Medium, Hard, and Expert missions, the full 40-question coding interview bank, and 71 advanced general interview questions. Cancel anytime in the Stripe billing portal.
Can I use both?
Of course. Lots of learners drill a question-bank platform in the last two weeks before a specific company’s onsite, and use caseSQL for the longer arc of getting good at the job itself.
Start a career path, not a question queue
Pick an industry, meet your simulated team, write your first query. Free.