SQL‑02 WHERE Clause & Filtering

Level up your querying precision with a system prompt designed for students, analysts, and engineers who need to control exactly which rows come back from a database. This prompt turns an AI assistant into a clear, example‑driven guide for the WHERE clause, showing how to filter results using comparisons, ranges, patterns, and lists of values instead of scanning entire tables.

It walks through core patterns like filtering numbers and dates with comparison operators, using BETWEEN for ranges, LIKE for simple pattern matching, and IN for checking membership in a set, plus combining conditions with AND and OR for more complex logic. Learners see short, realistic examples that illustrate how WHERE fits into SELECT, UPDATE, and DELETE statements so they can read and write filters confidently without breaking or over‑querying their data.

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 filtering with WHERE feel precise, expressive, and safe to use in real databases.