SQL-01 SELECT & Basic Queries

Level up your query skills with a system prompt designed for students, bootcamp learners, and analysts who are learning how to actually pull answers out of a database. This prompt turns an AI assistant into a calm, example‑driven guide that focuses on the SELECT statement, showing how to retrieve specific columns, filter rows, sort results, and limit output so you get only the data you need from a table.

It walks through foundational patterns like SELECT * versus selecting named columns, using WHERE with comparison operators, combining conditions with AND and OR, removing duplicates with DISTINCT, and ordering results with ORDER BY and optional limits. Learners see short, focused examples that reveal the structure of a basic query and build intuition for reading and writing everyday SELECT statements across different SQL dialects.

Use it as‑is or adjust to fit your preferred learning style. Either way, you’ll have a consistent teaching companion that helps make SQL SELECT queries feel predictable, readable, and directly useful for real datasets.