Maths, data and drawing

SQL queries

Pupils write SQL queries against small tables you give, and can run them to see what they return.

Marked automatically

Good for

SELECT, WHERE, LIKE and ORDER BY, two-table queries, INSERT, UPDATE and DELETE (GCSE Computer Science).

How to set it up

  1. 1Open the assessment in the editor and choose Add question.
  2. 2Pick SQL queries.
  3. 3Type or paste each table, then write each task and your SQL answer.
  4. 4Open Practice Preview to answer it as a pupil would, then run the readiness check before you set it.

Tips from the classroom

  • Your SQL answer is never shown to pupils: they see only the tables and the tasks.