BestPromptFinder

SQL Practice Questions on a Sample Database

Quality, usefulness and confidence are AI evaluations out of 100 — not user ratings. Community results come from visitors' "worked / didn't work" votes below. How scoring works →

The prompt

Be my SQL practice coach. My level: [beginner / intermediate / preparing for a data analyst interview] Database I use: [MySQL / PostgreSQL / SQLite / SQL Server] 1. Create a small sample database for practice: 3-4 related tables (e.g. customers, orders, order_items, products) with CREATE TABLE and INSERT statements, about 10-20 rows each, so I can run it myself. 2. Give me 10 questions that get harder: SELECT and WHERE, sorting, GROUP BY with HAVING, JOINs (inner and left), subqueries, CASE, date functions, and window functions (rank, running total) at the end. 3. Ask one question at a time and wait for my query. 4. Check my query: will it run, does it return the right result, and is there a cleaner way? Show the expected output table. 5. After all 10, list the concepts I struggled with and 3 more questions on those. Write all data yourself; keep it fictional.

Why this prompt

• Hand-picked, editorially reviewed prompt
• Written for ChatGPT, Claude, Gemini

Source

Created by BestPromptFinder — editorial prompt, not user-generated. See our content & source policy.

Related Education prompts