Lesson Plan

• Describe the purpose of the SELECT statement and the role of the WHERE clause.
• Identify appropriate comparison, logical, and special operators for single‑ and multiple‑criterion queries.
• Construct SQL queries that retrieve specific subsets of data using single or combined criteria.
• Test and modify queries to ensure correct results.
• Explain common errors such as missing quotes or incorrect logical operators.

• Computer lab with internet access
• SQL database software (e.g., MySQL, SQLite) or an online SQL editor
• Projector and screen for demonstrations
• Printed worksheet with practice queries
• Sample “Students” table data (digital or printed)
• Whiteboard and markers

Begin with a quick poll: Who has ever searched for specific information in a spreadsheet or app? Explain that databases use queries to retrieve exactly the data they need, and today we’ll focus on building WHERE clauses with one or more criteria. By the end of the lesson students will be able to write and test queries that filter records accurately.

1. Do‑Now (5'): Students answer “What is a query?” and write a basic SELECT * FROM Students; on paper.
2. Mini‑lecture (10'): Explain SELECT syntax and the WHERE clause; demonstrate single‑column criteria (e.g., Score > 80).
3. Guided practice (10'): Project a query, run it, and have students replicate on their computers.
4. Introducing multiple criteria (5'): Discuss AND, OR, NOT with an example filtering gender, age, and course.
5. Pair activity (10'): Students create a query using at least two criteria from the worksheet; teacher circulates to support.
6. Consolidation quiz (5'): Exit ticket – write a query to list female students aged 17‑18 studying Mathematics.

Summarise how the SELECT and WHERE clauses work together to filter data, highlighting the logical operators used. Collect the exit tickets to gauge mastery and assign a homework task: write three additional queries using LIKE, BETWEEN, and IN operators.