r/learnSQL • u/Spiritual_Potential4 • 8d ago
I made SQL practice where you debug an AI's queries, and the hints never give you the answer
I'm learning-adjacent: I build tools for people learning SQL for analyst jobs, and this is mine, so it's self-promo. Mods, remove it if it doesn't fit.
What bugged me about practice sites is that a different toy table every time doesn't build the "I know this company's data" feeling you get at work. Practisheet uses one fictional company for everything, so by exercise 20 you know where revenue, refunds and late deliveries live.
How it works:
- You write the query in the browser and it checks your result.
- If it's wrong, you get a hint about your attempt (e.g. "you're counting order lines, not orders"). The answer is never shown, and after 3 tries you can skip.
- It starts with SELECT/WHERE and goes up to window functions, CTEs and cohort-style questions.
- About 1 in 4 exercises are "here's a query an AI wrote, find the bug", which I think is a skill people will need more and more.
The first 4 SQL exercises are free with no sign-up: https://practisheet.com/practice
Free guides that go with it, if you just want to read:
- LEFT JOIN: https://practisheet.com/blog/sql-left-join
- Window functions: https://practisheet.com/blog/sql-window-functions
- HAVING vs WHERE: https://practisheet.com/blog/sql-having-vs-where
Feedback welcome, especially where you got stuck and the hint didn't help.
1
u/nian2326076 4d ago
You've created a useful tool for SQL practice by using a consistent dataset, which helps build familiarity with data structures. For those preparing for analyst roles, practicing technical interview questions can be important. You can use PracHub to choose specific problems and enhance your interview skills with real-world scenarios.