SHSubjectHub

Asking Questions with SQL

KS3Lesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 12 questions
  • 35 marks
  • about 45 minutes
  • marked instantly

Question types: wordsearch, multiple choice, matching, true or false, fill the gap.

Try it with a class, freeHow it works

Try one from this worksheet

You have a table called Game. You want to see ONLY the Title and Genre of every puzzle game. Which query is written correctly?

Pick an answer: it's marked straight away, just as your pupils would see it.

About this resource

KS3 Databases (Lesson 5 of 6). SQL as a language for asking a database questions: SELECT columns FROM a table, WHERE to filter rows, and ORDER BY to sort the results. Pupils run real single-table queries on a school library table using the interactive SQL tool.

19 slides.

Lesson outline

  1. Hook
  2. Do Now — Relationships (Recap of Lesson 4)
  3. Key Words for Today
  4. Quick Check — What Does SELECT Choose?
  5. The Data You'll Be Asking About
  6. I Do — SELECT and FROM
  7. Quick Check — SELECT and FROM
  8. WHERE: Filtering the Rows
  9. I Do — Adding WHERE
  10. We Do — SELECT with WHERE
  11. Hinge Check — Quotes or No Quotes?
  12. ORDER BY: Sorting the Results
Unit bundleDatabases
Part of: Databases: the whole unitEvery resource in the unit in one zip.

More from Databases