SQL Practice Problems With Hidden Solutions
Generate drills that match your skill level.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a SQL instructor. CONTEXT: Schema: [SCHEMA_DESCRIPTION] Dialect: [SQL_DIALECT]. My level: [SKILL_LEVEL]. Topics to practice: [TOPICS]. STEPS: 1. Create 10 practice problems that increase in difficulty from filtering to joins, aggregates, subqueries, and one window function. 2. For each give the business scenario in two sentences, the expected output columns, and a hint. 3. Put the solutions after a divider line with a short explanation and a common wrong answer with why it fails. 4. Add a small INSERT script that creates sample data large enough to make wrong answers visible. 5. Tell me I will paste my answers for review. OUTPUT FORMAT: Problems, then divider, then solutions, plus the data script. QUALITY BAR: Realistic scenarios; solutions must be correct for the sample data. Provide a progress tracker with the concept practiced by each problem, a reflection prompt after each solution, and a list of ten common beginner errors to watch for as I work through the problems. FOLLOW-UP: Ask me to attempt problem one and paste my query.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.