Lesson Plan

• Describe the purpose of each search operator (AND, OR, NOT, LIKE, >, <, =, >=, <=) in SQL queries.
• Construct correct WHERE clauses that combine multiple operators, using parentheses where needed.
• Apply the LIKE operator with % and _ wildcards to perform pattern matching.
• Use numerical comparison operators to filter records within specific ranges.
• Evaluate query results and troubleshoot logical errors in combined conditions.

• Projector and screen
• Computer lab with MySQL (or equivalent) installed
• Sample database (e.g., product, student, and order tables)
• Worksheet with practice scenarios and exercises
• Whiteboard and markers
• Printed handout of operator cheat‑sheet

Begin with a quick “What‑if” question: “How would you find all products priced under $50 that are in stock?” This activates prior knowledge of basic SELECT statements. Briefly remind students of the SELECT‑FROM‑WHERE structure and explain that today’s success criteria are to write accurate WHERE clauses using a range of operators.

1. Do‑now (5'): Students list any operators they already know on a sticky note.
2. Mini‑lecture (10'): Teacher introduces each operator with a concise example on the projector.
3. Guided practice (15'): Whole class works through the “Combining AND and OR” example, emphasizing parentheses.
4. Pair activity (10'): Learners create queries for two of the “Search Scenarios” and check each other’s work.
5. Whole‑class review (10'): Volunteers share their queries; teacher highlights common errors and correct usage.
6. Exit ticket (5'): Each student writes one WHERE clause that uses at least two different operators.

Recap the key points: logical AND/OR, the role of NOT, pattern matching with LIKE, and numeric comparisons. Collect exit tickets to gauge understanding, and assign a homework task to write five varied queries using a mix of operators from a provided dataset.