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 four paths are organized by industry — Marketing Analytics, Business Intelligence, Healthcare Analytics, Finance. 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
Not a focus
Yes
Data-project / take-home practice sets
Partial
Yes
Free tier with meaningful content
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, 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?
Four paths × 25 missions = 100 missions total today, 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.)?
No. caseSQL missions are set inside simulated companies (an e-commerce retailer, a hospital system, a fintech) rather than being tagged to specific real-world employers. If company-tagged drills are what you want, a question-bank or interview-prep platform is a better fit.
Does the free tier include the full 100 missions?
Yes — the fundamentals of SQL learning are free, including all shipped missions across every path. We’re building paid tiers for advanced features, but the core practice stays free forever.
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.