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

aicreatormentor Republished on Nov 16 0 Bookmarks 0 Copies
Bookmark 0

Prompt template

Usage instructions
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

Choose SQLite, PostgreSQL, or MySQL as the SQL dialect for your practice. The tutor advances through the named query topics and increases difficulty based on the sequence in the prompt

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

Up to 4 results. Images up to 2 MB; MP4, WebM, or MOV videos up to 4 MB each