
SQL SELECT, FROM and WHERE lesson for OCR GCSE Computer Science (J277), with editable PowerPoint slides, a student worksheet and full answers. SQL SELECT chooses fields, FROM names the table and WHERE filters the rows, which lets a query pull out just the records needed.
Written for J277/02 Computational thinking, algorithms and programming, section 2.2 Programming fundamentals (spec 2.2.3.4). Everything is editable, so you can adapt it to your class.
What’s included- PowerPoint lesson (14 slides) with teacher notes on every slide
- Student worksheet (Word), ready to print or edit
- Answer sheet (Word) with mark-scheme style answers for every question
By the end of the lesson students can:
- Explain what SQL is used for and what SELECT, FROM and WHERE each do
- Predict the result of a query on a table of records
- Write queries that pick fields and records with a condition, and run them from Python
Worksheet sections: A. Key words; B. Predict the results; C. Write and run queries; D. Exam-style questions; E. Challenge
Every lesson includes- Learning goals and a starter question
- Clear explanations, diagrams and worked examples (Python 3 throughout, with the OCR Exam Reference Language alongside)
- A quick check and a “your turn” task linked to the worksheet
- Exam-style questions with marks, and an exit ticket
- PowerPoint (.pptx) and Word (.docx), fully editable
- Works in PowerPoint and Google Slides
- Bright, clear GCSE design, consistent across the whole course
These are independent resources written for the Cambridge OCR GCSE (9–1) Computer Science specification (J277, version 3.1). They are not produced or endorsed by OCR or Cambridge University Press & Assessment. Spec point numbers are our own numbering of the specification statements.
More lessons in this series- Previous lesson: Records – OCR GCSE Computer Science lesson
- Next lesson: SQL wildcards and conditions – OCR GCSE Computer Science lesson
- Save with the bundle: Programming fundamentals Part 2 – OCR GCSE CS (14 lessons)
Last updated: November 2026.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.