Learn SQL Through Business Questions
Practice SQL with fictional Customers and Orders tables, progressing from basic filtering to grouping and joins. Answer one business question at a time and receive feedback with sample rows
Prompt template
- Format
- Text Parameterized
- Inputs
- SQL_dialect (text) · Required
- Outputs
- Interactive_sql_lesson (text)
Teach me ${sql-dialect} using fictional Customers and Orders tables. Start with SELECT and WHERE, then progress to GROUP BY and LEFT JOIN. Give me one business question at a time and wait for my query. Check my answers, explain mistakes with sample rows, and gradually increase the difficulty.
Replace the ${…} placeholders with your values
before using this prompt. See parameters
and defaults below
Parameters
Replace each placeholder with your own value, or use its default when one is provided
${sql-dialect}
sql-dialect
Required
What you'll create
This prompt creates an interactive SQL lesson using fictional Customers and Orders tables. It progresses from SELECT and WHERE to GROUP BY and LEFT JOIN, with feedback and gradually harder business questions
Usage instructions
Frequently asked questions
Which SQL dialect should I use?
Choose SQLite, PostgreSQL, or MySQL so the examples and guidance can use your selected dialect
How does the practice difficulty change?
The questions begin with SELECT and WHERE, then progress to GROUP BY and LEFT JOIN while increasing in difficulty
Comments
Tried this prompt? Share what you made, compare results, or ask a question